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 |
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
How we will implement Pushdown Optimization and Types in Informatica with better examples
What is the Difference between SetVariable and setmaxvariable in informatica?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
Could you explain what is enterprise data warehouse?
Hi experts, can anyone tell how much we use plsql in real time
Hi All can anyone tell me where i will get Informatica training in Mumbai?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How you count the number of records available at your source?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.