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
Implementation methodology
What is the different lookup cache(s)?
where to store informatica rejected data?
Can we create a node as a gateway node and the same node can be assigned to a grid?
update strategy transformation in informatica
Where can we find the throughput option in informatica?
What is mapplet in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How is union transformation utilized?
What is a difference between complete, stop and abort?
Different sorts of metadata that stores in the storage facility?
How can you validate all mappings in the repository simultaneously?
What are connected or unconnected transformations?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is an aggregator transformation?