Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / rayudu
Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
T/r.
Regards,
rayudu.
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the different lookup cache(s)?
differences between service based and product based?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the types of lookup transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the difference between informatica6.1 and infomatica7.1
How do you load only null records into target? Explain through mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the benefit of partitioning a session?
What is data transformation manager process?
Write the unconnected lookup syntax and how to return more than one column.
How can a transformation be made reusable?