Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 13216 Views
- I also Faced
- E-Mail Answers
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
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is meant by LDAP users?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
waht type of interface is used for testing the data in informatica
What are the differences between a connected lookup and unconnected lookup?
Performance tuning in UNIX for informatica mappings?
How can informatica be used for an organization?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Tell me about Propagate functions in informatica
What is a standalone command task?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Quickly characterize reusable change?
What does update strategy mean, and what are the different option of it?
Explain the use of aggregator cache file?
What is a shortcut and copy in Informatica and how two are different with each other?
