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

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1924


what is the difference between informatica6.1 and infomatica7.1

2283


What is an unconnected transformation?

1089


Explain the mapping variable usage example in informatica

1167


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1084


What is the benefit of partitioning a session?

1184


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525


Enlist some properties of sessions.

1087


What is the meaning of up gradation of repository?

1994


Which development components of informatica have the highest usage?

1056


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1134


What is an active transformation?

1116


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

2361


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1284


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2032