I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
- 6 Answers
- 13775 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / manu
Hi IBM,
I have a solution for this.
1) From source qualifier get the records to the Expression.
2) Use one Sequence generator in which set the max value as
3 , enable cycle option. Connect it to the expression.
3) then use router & create 2 groups, 1st group condition
as Next value = 1 another as next value = 2 and default.
4) These should be connected to the 3 target tables.
The requirement will be achieved.
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
define galaxy repository in informatica
differences between service based and product based?
What are the tasks that source qualifier perform?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain what is informatica metadata and where is it stored?
generate date / time dimension in informatica
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.
What are the settings that you use to configure the joiner transformation?
Differences between version 7.x and 8.x.
How to Create a folder using pmrep command?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the new features of Power Center 5.0?
Under which circumstances, informatica server creates reject files?
How can we improve session performance in aggregator transformation?
