if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
Answer Posted / chegu
Both records satisfying the conditions go to target
like the emp table has 14 rows,in router we pass the emp data and create 2 groups as sal_1=sal>1100 and sal_2=sal>1500 and then connect to two target tables run workflow,we get 18 records as output satisfying first and second conditions.
Thank you
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Explain Dataware house architecture .how data flow from intial to end?
How to implement security measures using repository manager?
Separate from an archive server and a powerhouse?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the modules in Power Center
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a predefined event?
What is the procedure for creating independent data marts from informatica 7.1?
what is the complex transformation you used in informatica
Explain the different lookup methods used in informatica?
How to configure mapping in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how to create user defined function (udf) in informatica
How big was your fact table