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
- 12191 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anand kumar
We can do this in the following.
Take the sequence generator t/r
set the properties like
Start value 1
End value 2
and also Enable cycle option
connect the nextval port to the router T/r
port "SGTNO"(created by you) and also connect the ports
from source qualifier to the router t/r
Now given the first condition like
SGTNO=1 then go to first target
otherwise go to second target(here no need to mention the
second condition).
If I went wrong, please let me know
Thanks
Anand Kumar
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do you load first and last records into target table?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Define mapping and session?
Can u generate reports in Informatica?
What is an aggregator transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What does role playing dimension mean?
What are the issues you have faced in your project? How did you overcome those issues?
What is a repository manager?
Explain why we use partitioning the session in informatica?
What is DR strategy for Informatica project?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Why do you use Mapping Parameter and mapping variable?
What is a filter transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
