Can we update a target table (without primarykey) by using
update strategy transformation?
Answer Posted / mithilesh kumar rai
With Same logic with Update Strategy tr,
just Select Primary Key Option in Target Table Definition.
It will work without defining the Target table.
Regards
Mithilesh Kumar Rai
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Mention a few design and development best practices for informatica?
Write the program through which the records can be updated?
Explain direct and indirect flat file loading (source file type) - informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a code page?
What are active transformations.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How would you join a node to the already existing domain?
design of staging area?
How do you promote a non-reusable transformation to reusable transformation?
What is sq transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is status code in informatica?
Did u used latest transformations of 8.6.0? for what?
What does refresh system mean, and what are its distinctive choice?