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 |
State the limitations where we cannot use joiner in the mapping pipeline?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
How to eliminate duplicate records in informatica mapping? Explain with an example....
How to create a non-reusable instance of reusable transformations?
If I have a index defined on target table and if set it to bulk load will it work ?
How can you define user defied event?
How to jion 2 tables, without using any condition?
server hot-ws270 is connect to Repository B. What does it mean?
which transformation uses cache?
what is the gap analysis?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
can v update d records in target using update stargey without generationg primary key ? explain