Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

a soure table has 100 records how to load into 3 target
tables in a cumulative order
source target1 target2 target3
--------- -------------------------------------
1-100 1 2 3
4 5 6
- - -
98 99 100

Answer Posted / babu

Hi,

mapping:
Src==>SQ==>Exp(Nextval,Src_column)==>Rtr(3 Groups)==>T1,T2,T2
||
Seq


the above dagram represents the data flow from source to targets


Seq:Sequence generator from generate the sequence
numbers(1,2,3)only Max Val=3,please enable cycle option.

Rtr:Router transformation have 3 groups,Grp1,Grp2,Grp3
Grp1=1 ==>T1
Grp2=2 ==>T2
Grp3=3 ==>T3

please let me know if any thing wrong.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the advantages of informatica.

1064


Define the various join types of joiner transformation?

986


How do you take back up of repository?

1158


How can we handle two sessions in informatica?

1029


Differentiate between a repository server and a powerhouse?

1116


How to update a particular record in target with out running whole workflow?

1575


EXL informatica Questions

1384


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866


in reporting we add some new objects,how we get the count of the newly added objects to the report

2191


Why update strategy and union transformations are active?

1038


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

4725


How to improve the performance of a session using sorter transformation?

1142


How to generate or load values in to the target table based on a column value using informatica etl tool.

1062


Define filter transformation?

1092


What all are steps in up gradation of Informatica server?

1043