Q: How to Avoid Duplicates Records in target Table by Using Lookup?

Informatica Interview Questions and Answers, Informatica Real time Issues and Scenarios.

Q: How to Avoid Duplicates Records in target Table by Using Lookup?

Answer:  Below are the ways to find that:

1. Connected lookup: Use a Connected lookup with Enabled Dynamic Cache. and Please check the Output Port of the NewlookupRow(Which WIll be Inserted into the target Table). lookup will Decide whether the incoming record is existed or not in the table cache?

2.UnConneted Lookup: Create An UnConnected Lookup. and Call the lookup in Expression Transformation and Please Check the Lookup Condition Port Value(NULL/NOT NULL) to decide whether the incoming record already existed in the target table or not?

Loading Techniques in ETL at Database end

Informatica Interview Questions and Answers, Informatica Real time Issues and Scenarios.

Loadinig Techniques in ETL Loading at Database end.

Answer: There are two Type of Loading Techniuqs while Loading data into Database tables.

1. Direct Load

2.Conventional Load

Direct Load:

Data will be Loaded first into table and then it will check the Constarints defined on the table.

it will be faster loading.

Conventional Loading:

Data will loaded into table after Checking the Constraints defined on the table. if the data saticifies the Constarint Conditions then only data will be Loaded into table. otherwise it will not load and job will fail.

compared with Direct loading Conventional Loading is little slow but Safer in Loading.

Direct Loading, if we have any data issues then we need to Clean the table to correct the Bad data. becuase the data will be loaded before constraint checking.

in Conventional loading,if we have any data issues then data will not be loaded into table. before loading data it will fail.

Thanks,

Anilkumar.