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 |
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
in oracle write query yourname+1 from dual
What are partitions in informatica and which one is used for better performance?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
What are the new features of informatica 9.x in developer level?
how to create user defined function (udf) in informatica
how to join the two flatfiles using the joiner t/r if there is no matching port?
How will the document be delivered to me?