Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load first and last record from a flat file
source to target?
- 7 Answers
- 29158 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / srinu
I have an IDEA,
After sql Trans,go with AGG,RANK transformation,
in RankTrans Properties set the rank 1 only---1 row returns,
In AggTrans Dont do any column for Group--Last row returns,
We need 2 Target tables. 1 for 1st record,2 for last record,
if u using the UNIONtrans one Target table is enough,,,
i think it wii help u,,,,,,srinu,,,,,,,,,
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
How do you load first and last records into target table?
What is the fact table?
What is workflow? What are the components of the workflow manager?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is workflow? What are the components of workflow manager?
What is the surrogate key?
In which transformation you cannot drag ports into it?
How will the document be delivered to me?
What is dynamic cache?
What is the sequence generator transformation in informatica?
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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is a standalone command task?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
