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 |
Which transformation is needed while using the Cobol sources as source definitions?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
How will u pas the data with out debugger?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
How to eliminate duplicates in FF and oracle both
Design a mapping to get year of join for each employee.
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
Three date formats are there . How to change these three into One format without using expression transformation ?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?