-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
Amritendra kumar
- Feb 29th, 2008
As per my openion it will insert only because it give preference to session
chandrarekha
- Feb 5th, 2008
It performs insert operation,because session overwrites the mapping level properties
-
Informatica source and targets with same fields
We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?
sandeep.vaishy
- Jan 14th, 2008
First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1...
sekhar.ganta
- Jan 3rd, 2008
here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3 select * from emp where (empno,0) in (select empno,mod(rownum,3) fro...
