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


Please Help Members By Posting Answers For Below Questions

wat are deployement groups in informatica, how it will be used for developers

1250


Explain Dataware house architecture .how data flow from intial to end?

2121


How to implement security measures using repository manager?

601


Separate from an archive server and a powerhouse?

491


How to generate or load values in to the target table based on a column value using informatica etl tool.

606






What are the modules in Power Center

1231


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

6467


What is a predefined event?

656


What is the procedure for creating independent data marts from informatica 7.1?

563


what is the complex transformation you used in informatica

2186


Explain the different lookup methods used in informatica?

585


How to configure mapping in informatica?

674


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1656


how to create user defined function (udf) in informatica

782


How big was your fact table

1313