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
- 13067 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
Where can we find the throughput option in informatica?
Partition, what happens if the specified key range is shorter and longer
Explain the shared cache and re-cache?
What is parallel processing in informatica?
What all are steps in up gradation of Informatica server?
Under which circumstances, informatica server creates reject files?
Briefly define a session task?
Which files are created during the session rums by informatics server?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can we remove the duplicates from flat file source?
write a query to retrieve the latest records from the table sorted by version(scd)
What is meant by incremental aggregation?
