@@aabyaz5124 you can create another account using one email id with different user name, then install secure agent again and try.

@@RiyaDhar-v3u in that case you will have value Y for one record and value N for other record.

@@anilanche5753 hi, you need to redevelop the datastage jobs in iics based on the logic implemeted in datastage.

@@itsranjan2003 we don't have any migration tool ? And can we do export and import options?

@@anilanche5753 I have not heard about any migration tool. Pls raise a informatica global support ticket, they may suggest if they have any such tool available.

Export and import will work for powercenter and iics code only..

@@itsranjan2003 okay I will do it sir, in the mean while if you get anything please let me know sir

@@PradeepKanaparthy use expression after sequence generator and map the next val to targets

​@@itsranjan2003 i connected seq_gen -> expresion -> tgt1 seq_gen -> expresion -> tgt2 src- > expr -> router -> tgt1 and tgt1 are connected. please suggest me how to achieve it.

@@PradeepKanaparthy add one expression transformation after sequence generator, map nextval to expression, from expression map the field to those three targets.

@@mdsaad9190-l2e hi, please try replication task..

Hi, have you provided the param file path and param file name in taskflow-->data task--> input fields. Pls check. It should work.

@@rsmchittithalli7334 thanks

If you have created the service account correctly and downloaded the json file and provided the required details correctly while creating the connection , it should work fine. Seems you might have not provided the details correctly while creating the connection.

@@rsmchittithalli7334 thanks

for schema, define parameter type as "connection" and for tables define parameter type as "object" while creating the input parameters.

yes, you need to define the batch size at target properties based on which the number of records will be inserted in one go. Regarding trigger and validation rules, informatica will work similar like data loader as these rules are affected only after the records are inserted into the target sfdc objects. If you don't want all fields to be updated as part of upsert functionalities, you have the option to insert records in one flow and update the object by mapping the required fields in another flow. Using Informatica, you have the option to transform the data( join multiple objects, filter records, aggregate data etc..) in a better way in comparison to data loader. Regarding the

to verify the column and data types you need to use the hard coded db/file connection and tables, then only you will be able to see the table column and data types. Pls refer my video 6.7

I saw that, it is related to parameterization. All I want to extract all the columns and their data type of source and compare with previous days same source structure Any function which can extract columns name and data type in comma separated list you know can be used

@@kieees_7601 you can keep first parameter with first paramter value. 2nd paramter with 2nd paramter value etc..

@@itsranjan2003 for example I am running Two mappings each has different source tables and different target tables and I can use one single parameter file ? In order to mention two different source tables and two different target tables from different mapping, the same single parameter file ? Like first_src_table= name First_tgt_table =name Above for first mapping. Second _src_table= name Second_tgt_table =name Above for second mapping?

@@kieees_7601 yes, you can use this..

Thank you.

pls check if you have selected the field delimiter properly,

please try with replication task , multiple source and target tables can be used in this task.(my video section 4.3 ).

@@itsranjan2003 thank you

@@itsranjan2003 is it also possible to have the source tables coming from different databases and different schemas within the databases and achieve that with single Replication task ? Or should we create separate replication task for database and schema specific? Note: But, target database and schema is constant for all the different sources databases

@@kieees_7601 I think it will allow tables from one database only in one replication task. for multiple databases and schemas, you may need to use multiple replication tasks.

@@kieees_7601 i think mass ingestion technique can be applied from IICS like from s3 to snowflake staging we need to run taskflow with help of mass ingestion . so it snowflake schema get load everyday basis .

Yes, please refer the steps..

@@itsranjan2003 Thank you for your efforts Ranjan!!

it will have project_id, private_key , client_email etc .. please refer the URL for generating service account developers.google.com/workspace/guides/create-credentials#service-account

after you login to snowflake, in left side, click on Admin-->Accounts. Then scroll the cursor to the account name , you will find one notification symbol, click on that , then you will see one URL, from the URL, copy the part which is there after "" and before ".snowflakecomputing.com". For example : if vabfghj-oiujk876767.snowflakecomputing.com is the URL, account will be vabfghj-oiujk876767

@@itsranjan2003 Thanks !

Use OR operator..

use hard coded connection/object, then update the field, then parameterize the connection / object.

@@itsranjan2003 I still don't understand how this will work. When I am hardcoding and updating the fields everything seems fine at target field mapping but when I parametrize source, the target shows some fields unavailable for field mapping.

@@ShaileshNavghare-n6x pls watch my video in section 6.7

use the hard coded connection value, update the date format, validate it, then parameterize the connection/object again.

@@itsranjan2003 super sir. It worked! Thank you

use hard coded connection/object, then update the field, then parameterize the connection / object.

Best practice is to create separate connections for source and target databases or file path.