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 / sid
take a look t/f and a update strategy t/f. basing on look
up , if the record exits in target then reject it ,if not
exit insert it,and if the record exist but it is changed
then update it
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
How we can create indexes after completing the load process?
have u done any performance tuning? how u ll do?
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?
What is workflow monitor?
What is the benefit of session partitioning?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is exclusive and normal mode for repository services?
What is blocking transformation?
Is it possible to use a client with different version than that of its Informatica server?
waht type of interface is used for testing the data in informatica
Explain why we use partitioning the session in informatica?
What is meant by active and passive transformation?
Explain load alternative records / rows into multiple targets - informatica