What is router transformation
- 4 Answers
- 7400 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 |
What is mapplet and a reusable transformation?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
What are the different options available for update strategy?
what is the purpose of surrogate key and diff between primary key&surrogate key
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the circumstances that infromatica server results an unreciverable session?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the difference between Bulk Load and Normal Load
Teradata 
