without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / bj
With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How can you define user defied event?
what is the complex transformation you used in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
Under what condition selecting sorted input in aggregator may fail the session?
Please let me know how to make encryption and decryption with example?
What is the cumulative sum and moving sum?
What are the main issues while working with flat files as source and as targets ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is meant by lookup transformation?
Explain the etl program with few examples.
How to extract sap data using informatica?
Explain the code page compatibility?
What is the command used to run a batch?
What is the meaning of up gradation of repository?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?