What is router transformation
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 size of u r database?
How can you increase the performance in joiner transformation?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
When to use normalization transformation other than cobol source?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
How to go to the older version for a mapping?
What are the active and passive transforamtions?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
How do you join more than 3 flat files in informatica?