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
What is intricate mapping?
Explain about cumulative Sum or moving sum?
Why union transformation is an active transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the different clients of powercenter?
What is xml source qualifier transformation in informatica?
pmscmd startworkflow -sv
Can anyone tell me the new features in Informatica 9 Version?
Explain the types of transformations?
what is SDLC way of code development?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What differs when we choose the sorted input for aggregator transformation?
Write the advantages of partitioning a session?
What is the difference between STOP and ABORT options in Workflow Monitor?
Slowly changing dimensions, types and where will you use them