What is meant by target load plan?
How to join three sources using joiner?
How do you update the records with or without using update strategy?
What are the differences between source qualifier and joiner transformation?
How do you convert single row from source into three rows into target?
What are the types of schemas we have in data warehouse.
Why update strategy and union transformations are active? Explain with examples.
How do you load alternate records into different tables through mapping flow?
How do you load first and last records into target table?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain in detail scd type 2 through mapping.
How do you load unique records into one target table and duplicate records into a different target table?
Explain the different kinds of facts.
How do you load only null records into target?
What is fact table? Explain the different kinds of facts.