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 sessions and how many types of sessions are there?
Explain why we use partitioning the session in informatica?
how to load only the first and last record of a flat file into the target?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
how do u move the code from development to production?
what is degenerated dimension
What is the difference between STOP and ABORT options in Workflow Monitor?
how to load dimension table and fact table. plz tell me the steps.
What is meant by pre and post session shell command?
How can repository reports be accessed without sql or other transformations?
What is rank transformation?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.