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 |
What is joiner transformation in informatica?
what are presession,postsession success and postsession failure commands ?
What is data caches/ index caches?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What is joiner transformation?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Can we run session without using workflows?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
what is the process of target load planing?
TELL ME ABOUT WORK FLOW SCHEDULING?
which transformation uses cache?
can v update d records in target using update stargey without generationg primary key ? explain