sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answer Posted / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
Differentiate between a repository server and a powerhouse?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain what transformation and how many are there in informatica?
What is target load order?
What is confirmed fact in dataware housing?
Briefly define reusable transformation?
What is primary and backup node?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Global and Local shortcuts. Advantages.
How can repository reports be accessed without sql or other transformations?
What is an unconnected transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
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
How do you change a non-reusable transformation to reusable transformation?