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

following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?

Answer Posted / triveni

startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the various types of transformations.

1118


Is it possible to use a client with different version than that of its Informatica server?

1189


What is a pre-defined event and user-defined event?

1078


Suppose we do not group by on any ports of the aggregator what will be the output?

1096


What is decode in static cache?

1257


Enlist the differences between database and data warehouse.

1164


How many transformations can be used in mapplets.

1978


Why update strategy and union transformations are active? Explain with examples.

1278


Write the different tools in the workflow manager?

1112


Explain the mapping variable usage example in informatica

1223


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2368


what is the size of u r source(like file or table)?

2306


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2411


How can you differentiate between powercenter and power map?

1138


What is a transaction control transformation?

1258