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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is a predefined event?
What do mean by local and global repository?
In development project what is the process to follow for an etl developer from day1
Performance tuning in UNIX for informatica mappings?
How to load data in informatica ?
What is the status code in stored procedure transformation?
What is domain and gateway node?
permutations of mapplet
What is a dimensional model?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
expain about the tune parameters?
Where can we find the throughput option in informatica?
How might you approve all mappings in the archive all the while?
How to elaborate powercenter integration service?