Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 14595 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhinav
By using an UPDATE STARTEGY transformation.
DD_UPDATE = If the record alreadye exists
DD_INSERT = If the record is a new one
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is sorter transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What all join we can perform in LOOKUP transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is size of u r database?
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 olap (on-line analytical processing?
What are batches?
What is informatica? Why do we need it?
What do mean by local and global repository?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is union transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the procedure for creating independent data marts from informatica 7.1?
