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
Where is metadata stored?
Under which circumstances, informatica server creates reject files?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the new features of informatica 9.x at the developer level?
Whats there in global repository
What is the function of union transformation?
r u done any partitions in ur project?
Explain joiner transformation in informatica
How does a sorter cache works?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a difference between complete, stop and abort?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How we can create indexes after completing the load process?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.