Interested to Buy Any Domain ? << Click Here >> for more details...
Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
- 5 Answers
- 13229 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramana sreepathi
Take sequence generator connect nextval port to router
in router create 2 groups
in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2
in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3
in default group
trg3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is an Integration service in Informatica?
Write the advantages of partitioning a session?
Mention few power centre client applications with their basic purpose?
COM components can be used in Informatica
What is a repository manager?
How many types of sessions are there in informatica.please explain them?
What are the settings that you use to configure the joiner transformation?
What is a difference between complete, stop and abort?
Differentiate between a database and data warehouse?
What do you mean by channel change?
What is data movement mode in Informatica and difference between them?
Explain the types of lookup transformation?
explain about unit testing? in real time?
Performance tuning( what you did in performance tuning)
