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
Repository user profiles
What are data-driven sessions?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain pushdown optimization $pushdownconfig parameter - informatica
Enterprise data warehouse your projects phase by phase explain?
What is meant by LDAP users?
What is primary and backup node?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is parallel processing in informatica?
What is the session task and command task?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a joiner transformation?
Separate from a database, an information bazaar, and an information stockroom?
Explain sessions?
What does cheating measurement mean?