Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11623 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
How can repository reports be accessed without sql or other transformations?
How do you load unique records into one target table and duplicate records into a different target table?
Can informatica load heterogeneous targets from heterogeneous sources?
How to use procedural logic inside infromatica?
list out all the transformations which use cache?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Can anyone tell me the new features in Informatica 9 Version?
What are the different types of repositories created using informatica?
Different circumstance which drives informatica server to expel records?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the restrictions of union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to join three sources using joiner?
How do you update the records with or without using update strategy?
