What is the functionality of update strategy?
Answers were Sorted based on User's Feedback
Answer / sivaprasad
Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3
If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chluff12
to decide to insert, update, delete or reject the data.
Is This Answer Correct ? | 0 Yes | 0 No |
How can i send first half of the records to one target and Remaining to other target?
why do u use shortcuts in informatica.?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
Mention few power centre client applications with their basic purpose?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
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 .
How the Informatica Server reads perameter file?
Plz..let me know differences between Informatica 7.1 and 8.1?
how to import multiple flat files in to single target where there is no common column in the flat files
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Where is the cache stored in informatica?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.