without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / sujit
by the use of update strategy T/R we can insert new row and
updae a existing row on the time of T/R
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is mapplet in informatica?
Define mapplet?
Tell me about Propagate functions in informatica
Which files are created during the session rums by informatics server?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Informatica settings are available in which file?
What are the new features of informatica 9.x in developer level?
Explain load alternative records / rows into multiple targets - informatica
Explain the use of aggregator cache file?
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 ?
What is a sorter transformation?
What is DR strategy for Informatica project?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?