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 |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What is a stored procedure transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what r the values tht r passed between informatics server and stored procedure?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What are the new features of Power Center 5.0?
Explian the Process of deployment groups in informatica
What are the uses of etl tools?
what is incremental data aggregation?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Could any one to tell How to use the Oracle Analytic functions in Informatica?