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 |
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
how can we load starting with 11th record of a table from source to target
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
how do u tune queries?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is meant by lookup transformation? Explain the types of lookup transformation?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Can you generate reports in Informatcia?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
How many ways you create ports?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
what is informatica metadata?