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 |
How to delete duplicate records in a flat file source?
I want load the data into target with out 1st and last record.
what is parameter file?
Is there any way to read the ms excel datas directly into informatica?
If I am having 6 flat files in data. How can you load the data at a time
Separate from an archive server and a powerhouse?
can we override a native sql query within informatica? How do we do it?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Why is sorter an active transformation?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
what is the command to get the list of files in a directory in unix?