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

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1871


If informatica has its scheduler why using third party scheduler?

778


What could be the possible resons of locks by user?

665


What does “tail –f” command do and what is its use as an Informatica admin.

631


whats the logic to load the lower level of granularity of data to fact table.

1803






what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1875


What is the difference between informatica 7.0 and 8.0?

569


wf dont have integration severances how you can run?

1541


When do you use sql override in a lookup transformation?

589


What is the need for an etl tool?

638


Which version configuration tool used in ur project?

2770


Define the various join types of joiner transformation?

561


Explain lookup transformation is active in informatica

662


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

633


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

1699