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.
Answer Posted / usha
seq g
|
|
s-->sq--->RTR
in router netval=1
nextvale=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Describe data concatenation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Is there any way to read the ms excel datas directly into informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
In development project what is the process to follow for an etl developer from day1
What are mapplets? How is it different from a Reusable Transformation?
What is a passive transformation?
What is the advantage of informatica?
What is workflow? What are the components of workflow manager?
What is target load order?