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 / gangadhar

Hi suresh you are 50% current

sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3

drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes

later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3

first group connect to T1
second group connect to t2
third group connect to t3

is 100% correct

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2323


How to partition the Session?

1092


define galaxy repository in informatica

2209


What is a joiner transformation and why it is an active one?

1065


What are the modules in Power Center

1669


What are pre and post-session shell commands?

1291


How does the aggregator transformation handle null values?

1134


What is the difference between stop and abort in informatica

1079


what is the hint? how to use it to reduce the query processing in program?

7780


Explain how to import oracle sequence into informatica?

992


lookup transformation with screenshots

3988


What is meant by a domain?

1114


How we can create indexes after completing the loan process?

1188


What are the performance considerations when working with aggregator transformation?

1133


what is diff b/t sorter t/r and agg have the option sorter property...

2164