Un-Answered Questions { Data Warehouse }

What is meant by target load plan?

550


How to join three sources using joiner?

567


How do you update the records with or without using update strategy?

658


What are the differences between source qualifier and joiner transformation?

594


How do you convert single row from source into three rows into target?

600


What are the types of schemas we have in data warehouse.

526


Why update strategy and union transformations are active? Explain with examples.

703


How do you load alternate records into different tables through mapping flow?

1286


How do you load first and last records into target table?

660


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.

768


Explain in detail scd type 2 through mapping.

609


How do you load unique records into one target table and duplicate records into a different target table?

703


Explain the different kinds of facts.

560


How do you load only null records into target?

738


What is fact table? Explain the different kinds of facts.

610