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?
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.