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 to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.

Answer Posted / satya

after the SQ have EXPR t/r and add sequence to have unique
no's. add rank t/r get the ranks and have two filters one
for no=1 and other is for no=5 write them to the same target

hope this will address your scenario.

For more info reach me at satya.ylv@gmail.com

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository? And how to add it in an informatica client?

1195


What are the types of schemas we have in data warehouse.

1005


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

2410


What do you mean by channel change?

1109


What are the guidelines to be followed while using union transformation?

1208


tell me 5 session failure in real time how can you solve that in your project?

2393


What is the advantage of informatica?

1126


What is the difference between STOP and ABORT options in Workflow Monitor?

1312


Is there any way to read the ms excel datas directly into informatica?

1070


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2303


What is informatica worklet?

1116


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265


Explain lookup transformation is active in informatica

1150


What does update strategy mean, and what are the different option of it?

1141


Can you use flat files in Mapplets.

2715