Interested to Buy Any Domain ? << Click Here >> for more details...
What is router transformation
- 4 Answers
- 6971 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 |
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Explain what are the different types of transformation available in informatica.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Differentiate between a database and data warehouse?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
Mapplets can you use an active transformation in a mapplet,
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
waht type of interface is used for testing the data in informatica
How will you check the bottle necks in informatica? From where do you start checking?
Teradata 
