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

What is meant by active and passive transformation?

0 Answers  

What are the advantages of informatica?

0 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

What is a sorter transformation?

0 Answers   Informatica,




Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

 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,

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

Explain the different lookup methods used in informatica?

0 Answers  

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

What do you mean incremental aggregation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories