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
- 11414 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3
In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is informatica worklet?
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?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How can we remove the duplicates from flat file source?
Explain target update override in informatica
How do you load only null records into target?
What is decode in static cache?
What are the differences between oltp and olap?
What are the prerequisite tasks to achieve the session partition?
What is the reusable transformation?
What is workflow monitor?
What are the types of lookup transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain dynamic target flat file name generation in informatica
