Un-Answered Questions { Data Warehouse }

What is meant by target load plan?

556


How to join three sources using joiner?

571


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

664


What are the differences between source qualifier and joiner transformation?

598


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

605


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

531


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

714


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

1294


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

666


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.

773


Explain in detail scd type 2 through mapping.

611


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

710


Explain the different kinds of facts.

566


How do you load only null records into target?

742


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

614