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 |
how will you remove the duplicate records from flat file without using sorter?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to join three sources using joiner?
What is substr in informatica?
Explain lookup transformation in informatica
What is the use of source qualifier?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What do you mean by enterprise data warehousing?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
How do you implement configuration management in Informatica?
Does an informatica transformation support only aggregate expressions?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,