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
- 12866 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / anu
sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=300
currval=1
cycle check it save it.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
How to extract sap data using informatica?
What are the various types of transformation?
what is the size of u r source(like file or table)?
How do you migrate data from one environment to another?
How to update a particular record in target with out running whole workflow?
How to create a non-reusable instance of reusable transformations?
Explain transaction control transformation in informatica
wat are deployement groups in informatica, how it will be used for developers
Suppose we do not group by on any ports of the aggregator what will be the output?
Did u used latest transformations of 8.6.0? for what?
Performance tuning in UNIX for informatica mappings?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can u generate reports in Informatica?
What is the difference between stop and abort in informatica
Differentiate between reusable transformation and mapplet.
