Interested to Buy Any Domain ? << Click Here >> for more details...
in my source i have 100 records, and 3 targets, i want to
load
1st record into 1st target,2nd record into 2nd target,3rd
record into 3rd target again 4th target into 1st target and
vice versa,how to achieve this?
- 3 Answers
- 13629 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / venkatesh.malneni
here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r
the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3
or if u use sequence generator the flow will be
sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the scenario which compels informatica server to reject files?
Can we create two repositories on same database instance in oracle?
What is a dimensional model?
What is a grid in Informatica?
What is DR strategy for Informatica project?
Separate from a database, an information bazaar, and an information stockroom?
What is the need of an ETL tool?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Clarify the utilization of aggregator cache record?
How do you load unique records into one target table and duplicate records into a different target table?
What are the different types of repositories created using informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the restrictions of union transformation?
