Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Answers were Sorted based on User's Feedback
Answer / viresh
Usually in RTR we create various groups we certain conditions.
If u have two target then use two filters and put the filter
condition.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / amit
RTX having two groups user defined and one default .
for user defined use filter from SQT and put negation of
all coditions with AND in default... ex.u have 2 grps dept
= 20 and default dept !=20
| Is This Answer Correct ? | 2 Yes | 0 No |
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
How to identify this row for insert and this row for update in dynamic lookup cache
How to go to the older version for a mapping?
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
How You Pull the records on daily basis into your ETL Server.
What is workflow monitor?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
hi all, Can anyone please tell me the relationship between informatica and business objects
Could any one to tell How to use the Oracle Analytic functions in Informatica?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?