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

Better to take Sequence generator t/r. initial value 0 and
current value is 1 and increment by 4 . It is suitable for
ur query

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

750


Enlist the various types of transformations.

566


What is session task and command task?

660


What are roles and groups and benefits of using them?

583


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1788






Enlist the tasks for which source qualifier transformation is used.

598


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

656


Separate from a database, an information bazaar, and an information stockroom?

621


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1705


In warehouses how many schemas are there?

596


What are the transformations that are not supported in mapplet?

610


How do you change a non-reusable transformation to reusable transformation?

606


What is meant by query override?

648


How can we use mapping variables in informatica?

606


What is Cognos script editor?

3801