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 happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
What are the phases in SDLC?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
in a table it has 200 rows the query is select 150 from tablename.whats the output
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What all are steps in up gradation of Informatica server?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the status code?
What are pre and post-session shell commands?
list out all the transformations which use cache?
Kimball and Inmon methodologies?