one source to target loading insert new rows and update
existing rows?
Answer Posted / jay
SQ ---------> UPD --> TRG
| ^
| |
--> LKP --
In update startegy, just give type as formula
iif(isnull(LKP_Col1), 0, 1)
0 --> DD_INSERT
1 -->DD_INSERT
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the advantage of informatica?
How to create or import flat file definition in to the warehouse designer?
Explain sessions. Explain how batches are used to combine executions?
Informatica settings are available in which file?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to go to the older version for a mapping?
How might you approve all mappings in the archive all the while?
What is difference between a gateway node and worker node?
What is an unconnected transformation?
What is InformaticaPowerCenter?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is workflow manager?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Write the program through which the records can be updated?