there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?
Answer / gm
Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET
In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)
Is This Answer Correct ? | 8 Yes | 0 No |
Explain in detail scd type 2 through mapping.
how can import the data from the flat files?
whatis the default data driven operation in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the types of maping wizards that r to be provided in Informatica?
How to handle changing source file counts in a mapping?
In a sequential batch can u run the session if previous session fails?
What is workflow manager?
What is resilience time?
Explain joiner transformation in informatica
How union transformation is active ?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties