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.
What are the differences between oltp and olap?
What are the types of schemas we have in data warehouse and what are the difference between them?
Differentiate between reusable transformation and mapplet.
Why update strategy and union transformations are active?