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
difference between repository database and repository service?
What is the need of an ETL tool?
Can we create a Integration service without a Repository service and vice versa?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is dimensional table? Explain the different dimensions.
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.
How we can create indexes after completing the loan process?
what is SDLC way of code development?
Which transformation is needed while using the Cobol sources as source definitions?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to create the source and target database connections in server manager?
whats the logic to load the lower level of granularity of data to fact table.
What is the command used to run a batch?
What does command task mean?
What is the difference between STOP and ABORT options in Workflow Monitor?