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
What does role playing dimension mean?
What are active and passive transformations?
Explain in detail scd type 2 through mapping.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we use mapping variables in informatica? Where do we use them?
Write the advantages of partitioning a session?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can you validate all mappings in the repository simultaneously?
Differentiate between source qualifier and filter transformation?
How union transformation is used?
What is a transaction control transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
wat are deployement groups in informatica, how it will be used for developers
What all join we can perform in LOOKUP transformation?
How can you generate reports in informatica?