If we set dd_insert in mapping and Delete in session properties what will happen.?
Answers were Sorted based on User's Feedback
Answer / sweta kedia
Yes it will perform delete as session properties overrides
mapping properties.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / insha
It will perform delete operation since session defines run
time properties of mapping
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / usha
It will perform delete.
because session properties overide mapping properties.
| Is This Answer Correct ? | 3 Yes | 1 No |
Write the different tools in the workflow manager?
What is meant by pre and post session shell command?
What is CHECK-IN CHECK-OUT. Please explane me?
What is depict expression change?
What do mean by local and global repository?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
How can you define a transformation? What are different types of transformations in Informatica?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What does command task mean?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Explain Dataware house architecture .how data flow from intial to end?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?