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
- 29463 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
Differentiate between Load Manager and DTM?
Explain joiner transformation in informatica
What is rank index in rank transformation?
What is rank transformation in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a code page?
Explain pushdown optimization $pushdownconfig parameter - informatica
In which transformation you cannot drag ports into it?
Why filter transformation is an active one?
What is fact table? Explain the different kinds of facts.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Enlist few areas or real-time situations where informatica is required.
What is an expression transformation?
