On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / rohan
Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define enterprise data warehousing?
How does the aggregator transformation handle null values?
What do you mean by filter transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How many number of sessions can one group in batches?
Differentiate between reusable transformation and mapplet.
What are the mapping parameters and mapping variables?
Do you find any difficulty while working with flat files as source and target?
How to create a non-reusable instance of reusable transformations?
How to generate sequence numbers using expression transformation?
what is the Default Source Option For Update Strategy Transformation?
What are the restrictions of union transformation?
Explain the types of transformations?
According to his methodology what all you need before you build a datawarehouse
What are the basic requirements to join two sources in a source qualifier transformation using default join?