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...

Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?

Answer Posted / srinivas

sequence generator>expression trans>router>targets

in router create 2 userdefined groups, 1 default group.
ie total 3 o/p groups
group1 condtion . mod(nextval,3)=0
group2 condtion . mod(nextval,3)=1
group3 condtion . mod(nextval,3)=2

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how would u estimate the size of Aggregator transform data and index cache?

2005


flat filevalidation in informatica

2200


Two default user groups created in the repository are____and_____.

2105


explain the methodology of Data Warehousing?(Polaries)

2365


what are the facilities provided by data warehouse to analytical users?

2119


What is meant by incremental load?

1159


What do you understand by active and passive transformations?

980


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2169


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2546


can cubes contain measures ?

2073


how do u set partition points in the mapping?

2301


What is tracing level? How many types of transformations supported by sorted input?

1011


Explain about power designer data modeling software?

916


how do u really know that paging to disk is happening while u are using a lookup transform?

2037


State the differences between shortcut and reusable transformation

1115