I have in my source Records like 100,101,102 etc. I have
router transformation which has groups like one group is
empno=100, second group is empno>99. Now i want to know my
source record 100 loads into which group?
Answers were Sorted based on User's Feedback
Answer / santosh
The record will be loaded into both the groups.
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / rampriya
if your input satisfies the condition of all your input
groups, then it will go into all of your groups excluding
default group. thats the only reason why router
transformation is active transformation
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / abhishek kumar
my source record 100 loads into one group. because router
first check first group than after second conscecuently.
| Is This Answer Correct ? | 3 Yes | 11 No |
what is mean by flag 4 in update strategy t/r
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
While importing the relational source defintion from database,what are the meta data of source U import?
How to improve the performance of Aggregate transformation?
What is a router transformation?
What is the Difference between sorter and aggregator?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
can a port in expression transf be given the name DISTINCT
What is decode in informatica?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?