How many ways are there to do 'remove duplicate records in informatica'?
how DTM buffer size and buffer block size are related
How to merge First Name & Last Name?
Different circumstance which drives informatica server to expel records?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is Session and Batches?
What is dimensional table? Explain the different dimensions.
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
in a table it has 200 rows the query is select 150 from tablename.whats the output
what is the diff b/w target load plan and cbl?