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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of aggregator cache file?

689


Explain in detail scd type 2 through mapping.

621


What does command task mean?

618


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1644


What is the difference between stop and abort in informatica

669






How do you set a varible in incremental aggregation

1453


write a query to retrieve the latest records from the table sorted by version(scd)

641


How can we store previous session logs?

577


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1333


What is informatica etl tool?

558


Why union transformation is an active transformation?

663


Why is sorter an active transformation?

672


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1848


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

793


How can repository reports be accessed without sql or other transformations?

736