What is router transformation
- 4 Answers
- 5605 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravindra.15aug
One source and having multiple targets, it is nothing but
advanced filter. here we are having default group, by this
we can rejected rows.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krish
it is active transformation, we can use this for applying multiple conditions on data and we can load into multiple targets
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramkrish.143
When we want perform multiple condition to filter out data
then we go for router. (Say for example source records 50
filter condition mach 10 records remaining 40 records get
filter out but still we want perform few more filter
condition to filter remaining 40 records.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / c
Router T/R is active and connected T/R .It is used for filtering data for multiple condition and to load in multiple target table.Router T/r stores the rejected data which is not matched the condition in the informatica reserved space as default data.
| Is This Answer Correct ? | 0 Yes | 0 No |
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a filter transformation?
what are presession,postsession success and postsession failure commands ?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
Can we get 1st record through Informatica(without sequence number).
how to calculate the optimum cache size in aggregator transformation?
how can you load data into target table without leading zeor's
What is the difference between Active and Passive transformation?
How to handle changing source file counts in a mapping?
Enlist the advantages of informatica.
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
In operator is used in which transformation in informatica 8.6.0
Teradata 
