1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / prasuna

Answers were Sorted based on User's Feedback



if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / sujana

record goes 2 both tables..it wil be passed multiple times

Is This Answer Correct ?    28 Yes 1 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / manohar

the record is passed both groups when source having primary
key also

Is This Answer Correct ?    7 Yes 1 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / krish

the above ans is wrong sorry for posting it

Is This Answer Correct ?    2 Yes 0 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / srikanth

The record will go to the both 2 targets

Is This Answer Correct ?    2 Yes 0 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / prakash kumar kumhar

yes record will store in both target if you r not using any column as a primary key from source column.
if u are using any column from the source as a primary than it will load only in first target i think.

Is This Answer Correct ?    4 Yes 3 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / arunachalam

The record goes to both the tables

Is This Answer Correct ?    1 Yes 0 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / 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

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / nanda

The Record will go to default group

Is This Answer Correct ?    0 Yes 2 No

if i have a file having record sal=10000,and when use router with two groups having condition sal&g..

Answer / krish

HAY JUST GO THROUGH THE Q IT GIVEN AS ROUTER
SO, IN SECOND CONDITION U WILL FINE SAL=10,000
IF ITS FILTER THEN IN BOUT CONDITION'S
U WILL FINE THE SAL=10,000
THAT IS DIFF BETWEEN
FILTER AND ROUTER

THIS IS THE GOOD SENIOR0 FOR ROUTER AND FILTER DIFF

FOR VERIFICATION USE EMP TABLE
ONCE

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

What is pmcmd command?

0 Answers  

What is galaxy shema

2 Answers   CGI,

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,




Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

how many data models u have done in informatica project?

2 Answers   TCS,

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

Define mapplet?

0 Answers  

What is critical mapping?

2 Answers  

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

What is a grid in Informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories