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

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

what is correlated query?

2 Answers   IBM,

What are the modules in Power Center

0 Answers  

how do u move the code from development to production?

3 Answers  

Could you explain what is enterprise data warehouse?

0 Answers  




What is Cognos script editor?

0 Answers   Cognizant,

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

what we require for D.modelling?

1 Answers  

What is rank transformation in informatica

0 Answers   Informatica,

How to get EVEN & ODD numbers separately?

8 Answers  

what is the predefined port in dynamic lookup

2 Answers  

For more Informatica Interview Questions Click Here
Categories