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
- 11638 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
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are junk dimensions?
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
What is the difference between informatica 7.0 and 8.0?
Why filter transformation is an active one?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain joiner transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the use of source qualifier?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is complex mapping?
Enlist the differences between database and data warehouse.
explain abt ur project architecture?
What are the different versions of informatica?
Define mapplet?
