Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11539 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
SQ-->EXP-SEQ-RTR-TARGETS
Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the different dimensions.
How we can create indexes after completing the load process?
What is status code in informatica?
What is the way to execute pl/sql script using informatica mapping?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain lookup transformation source types in informatica
What is meant by lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the different options available for update strategy?
Informatica Checkpoints
What are different types of transformations available in informatica?
Difference between Target-based loading and constraint-based loading?
What do you mean by blocking transformation?
How many number of sessions can one group in batches?
