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 Posted / 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 |
Post New Answer View All Answers
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How many ways are there to create ports?
What is a stored procedure transformation?
How does a rank transform differ from aggregator transform functions max and min?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what is degenerated dimension?
what is the complex transformation you used in informatica
What all are steps in up gradation of Informatica server?
How can you define user defied event?
What is InformaticaPowerCenter?
What are the different components of powercenter?
How you can differentiate between connected lookup and unconnected lookup?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are ETL Tools?
How can you validate all mappings in the repository simultaneously?