How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
Answers were Sorted based on User's Feedback
Answer / swetha
In the Type2 maping we have three options to recognise the
newly added rows
Version number
Flagvalue
Effective date Range
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / atiric software(raja)
by flag value we can identify the newly inserted rows
| Is This Answer Correct ? | 1 Yes | 0 No |
What is data caches/ index caches?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the difference between SOURCE and TARGET BASED COMMITS?
waht type of interface is used for testing the data in informatica
Explain the pipeline partition with real time example?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How do you load unique records into one target table and duplicate records into a different target table?
What are the differences between oltp and olap?
How you know when to use a static cache and dynamic cache in lookup transformation?
How can one identify whether mapping is correct or not without connecting session?