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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to go to the older version for a mapping?

604


What is meant by lookup transformation? Explain the types of lookup transformation?

569


scenario where i can use only concurrent execution of workflow.

2546


What is fact table? Explain the different kinds of facts.

616


What are the main features of Oracle 8i with context to datawarehouse?

1682






What is the cumulative sum and moving sum?

756


What is the need of an ETL tool?

642


Clarify the utilization of aggregator cache record?

578


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


Write the unconnected lookup syntax and how to return more than one column.

597


Explain target update override in informatica

631


What are the uses of etl tools?

647


What are the advantages of using informatica as an etl tool over teradata?

567


What is joiner change?

681


What is session task and command task?

649