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 an Integration service in Informatica?
how do u tune queries?
How to import oracle sequence into Informatica?
What is the Rankindex in Ranktransformation?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
What is source qualifier transformation?
What is data movement mode in Informatica and difference between them?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
How to extract sap data using informatica?
major difference between normal loading and bulk loading?
What is Index Caches size?
Is it possible to define a single node as a Gateway node as well as worker node?