Differentiate between source qualifier and filter transformation?
Explain scd type 3 through mapping.
What is dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain in detail about scd type 1 through mapping.
Write the unconnected lookup syntax?
Write the unconnected lookup syntax and how to return more than one column.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is dimensional table? Explain the different dimensions.
What are the types of caches in lookup?
What are the types of caches in lookup? Explain them.
Differentiate between router and filter transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.