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 / sasi
the best way to do this use the slowy changing dimension in
the mappings-->wizzard-->slowly changing dimension-->type1
here u need to select the source and target tables.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
scenario where i can use only concurrent execution of workflow.
What is aggregator transformation in informatica?
Explain lookup transformation in informatica
What is standalone command task?
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 could be the possible resons of locks by user?
How to elaborate tracing level?
what are the deliverables?in your project?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Is it possible to revert a global repository to local one and why?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you update the records with or without using update strategy?
What is a dimensional model?
lookup transformation with screenshots
What do you mean incremental aggregation?