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


i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....

Answers were Sorted based on User's Feedback



i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / mithilesh kumar rai

step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.

step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.

Is This Answer Correct ?    13 Yes 2 No

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / davankumar

1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...

Is This Answer Correct ?    11 Yes 1 No

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / vidyadhar tilve

use transaction control

Is This Answer Correct ?    0 Yes 0 No

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / ramakrishna

simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

Two different admin users created for repository are ______ and_______

1 Answers  


What is meant by query override?

0 Answers  


Define maping and sessions?

3 Answers  


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


what is metadata?

6 Answers  


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


What is the Router transformation?

2 Answers   Informatica,


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


what is the process of target load planing?

2 Answers   IBM,


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


What are the two modes of datamovement in informatica sever?

2 Answers  


Categories