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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Enlist the various types of transformations.
What is session task and command task?
What are roles and groups and benefits of using them?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Enlist the tasks for which source qualifier transformation is used.
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.
Separate from a database, an information bazaar, and an information stockroom?
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
In warehouses how many schemas are there?
What are the transformations that are not supported in mapplet?
How do you change a non-reusable transformation to reusable transformation?
What is meant by query override?
How can we use mapping variables in informatica?
What is Cognos script editor?