I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 10249 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / teja_dwh
By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.
cheers
teja
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
difference between repository database and repository service?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Where are the source flat files kept before running the session?
How do you promote a non-reusable transformation to reusable transformation?
What are connected or unconnected transformations?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a surrogate key?
what is degenerated dimension?
How do you load unique records into one target table and duplicate records into a different target table?
How do you set a varible in incremental aggregation
What is a grid in Informatica?
What is Data Caches size?
Partition, what happens if the specified key range is shorter and longer
How you can differentiate between connected lookup and unconnected lookup?
Explain the aggregator transformation?
