Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 12140 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vani
Can it be done in this way....
1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.
If i am wrong please tell me....
| Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
What are the different components of powercenter?
What do you mean incremental aggregation?
what is degenerated dimension?
What is a joiner transformation and why it is an active one?
Briefly define a session task?
What are the types of caches in lookup?
How can informatica be used for an organization?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain sessions. Explain how batches are used to combine executions?
How can we use mapping variables in informatica?
What is resilience time?
Define mapping and session?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between reusable transformation and mapplet.
What is the need for an etl tool?
