if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups
what is the o/p in the target
Answer Posted / chandrasekar
The above scenario I took an one table like emp table, I
took the coloumn as deptno ,I have created 3 targets and
created one router T/r , condition like that one is
deptno>20 , deptno=20 and deptno<30.
In that if the deptno>20 condition satisfies then the
particular record who has deptno above 20 which can be
loaded into one target. The same as other 2 conditions. If
the condition satisfied then it can loaded to particular target.
if it wrong means please mail me chandranmca2007@gmail.com
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
What is repository manager?
What is the use of transformation?
What is the reusable transformation?
What is informatica etl tool?
What are the tasks that source qualifier perform?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How do you manage the Parameter files while migrating your data from one environment to another environment?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to load data in informatica ?
How to load a Dimension ? and how to load a fact table?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between router and filter?
How many dimensions are there in informatica?
How is union transformation utilized?