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 the difference between writing a joiner query in ANSI style and THETA style?

2386


Mention a few design and development best practices for informatica?

1004


Where can we find the throughput option in informatica?

1070


What are mapplets?

1282


How big was your fact table

1811


What is joiner transformation in informatica?

1054


What are the types of caches in lookup?

1055


Which transformation is needed while using the Cobol sources as source definitions?

1179


What is a filter transformation?

1050


can we override a native sql query within informatica? Where do we do it? How do we do it?

1063


What is the Rank index port in Rank transformation?

1066


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8229


How you can differentiate between connected lookup and unconnected lookup?

1065


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2051


How to load data in informatica ?

1030