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
Explain the use of aggregator cache file?
Explain in detail scd type 2 through mapping.
What does command task mean?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the difference between stop and abort in informatica
How do you set a varible in incremental aggregation
write a query to retrieve the latest records from the table sorted by version(scd)
How can we store previous session logs?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is informatica etl tool?
Why union transformation is an active transformation?
Why is sorter an active transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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.
How can repository reports be accessed without sql or other transformations?