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 are the transformations that are not supported in mapplet?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define mapplet?
What is the difference between router and filter?
What is the benefit of session partitioning?
explan ur project architecture?
Define joiner transformation?
Is it possible to revert a global repository to local one and why?
Implementation methodology
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Which is the t/r that builts only single cache memory?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to create Target definition for flat files?
How do you use reject loader.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?