How to load only the first and last record of a flat file into
the target?

Answer Posted / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does reusable transformation mean?

676


How you know when to use a static cache and dynamic cache in lookup transformation?

1341


Can we change Dynamic to Static or Persistent cache? If so what happens?

1730


Mention some types of transformation?

607


draw informatica architecture 8.6 ?

3472






HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1477


can u give example for factless fact table

5527


In warehouses how many schemas are there?

583


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

1695


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9166


How do you load only null records into target?

742


Differences between version 7.x and 8.x.

1419


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

728


How to configure mapping in informatica?

674


What is workflow? What are the components of workflow manager?

711