Interested to Buy Any Domain ? << Click Here >> for more details...
on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
- 4 Answers
- 8587 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arpit
For this a SCD type2 mapping has to be created which will handle both update and insert. This mapping will be having 2 target instances i.e. one instance for updating and other is for inserting records. Use router to divide the rows in two groups i.e. update and insert. In the pipeline for update target instance use the update strategy transformation for update.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Have you worked with/created Parameter file
Tell me about Propagate functions in informatica
What are the types of data warehouses?
Explain target update override in informatica
Where is metadata stored?
How identifying bottlenecks in various components of informatica and resolving them?
Which version configuration tool used in ur project?
Explain Dataware house architecture .how data flow from intial to end?
What is the different lookup cache(s)?
What is meant by LDAP users?
What are the different ways to implement parallel processing in informatica?
How can we create index after completion of load process?
What is update strategy transform?
list out all the transformations which use cache?
