sir i have doubt like we are giving two condition in filter transformation also using iff(deptid=10 and deptsal>50000) but you are telling only single condition in possible in filter transformation please answer this question?
By using filter transformation, u can load into only 1 target. But by using router, u can load in to any number of targets based on different conditions. In the above example, based on 3 conditions, data is loaded into 3 different targets.
Excellent explanation !
Sir is there any alternate way of defining target strcuture for Flat file ? It will be very difficult if we will have more number of columns .
Sir have you find out any alternate option??
❤
sir i have doubt like we are giving two condition in filter transformation also using iff(deptid=10 and deptsal>50000) but you are telling only single condition in possible in filter transformation please answer this question?
By using filter transformation, u can load into only 1 target. But by using router, u can load in to any number of targets based on different conditions. In the above example, based on 3 conditions, data is loaded into 3 different targets.
@@smirthi3693 Are u able to download Informatica Powercentre ?