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

explain about lookup t/r?

1 Answers   IBM,

How union transformation is active ?

2 Answers   Puma,

What is dimensional table?

0 Answers  

Explain the use of aggregator cache file?

0 Answers  

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,




What is the difference between Normal load and Bulk load?

5 Answers  

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

what is data driven?

1 Answers  

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

What do you understand by term role-playing dimension?

0 Answers  

For more Informatica Interview Questions Click Here
Categories