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

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

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you set a varible in incremental aggregation

1451


Differentiate between sessions and batches?

574


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1653


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

569


How do you manage the Parameter files while migrating your data from one environment to another environment?

553






Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1240


Explain constraint based loading in informatica

661


What are some examples of informatica etl programs?

537


How to start a workflow using pmcmd command?

713


What are the restrictions of union transformation?

581


What are the steps involved in the migration from older version to newer version of Informatica Server?

1585


How do you take back up of repository?

723


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1073


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1631


Enlist the differences between database and data warehouse.

550