how can we load first and last record from a flat file
source to target?
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
What is a rank transform?
what are the Methods For Creating Reusable Transformations?
While migrating the data from one environment to another environment how would you manage the connections?
What are active and passive transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the use of an aggregator cache file?
design of staging area?
can you please explain me pre session and post session options?
What is a joiner transformation?
How might one distinguish in the case of mapping is right or not without associating session?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How many ways a relational source definition can be updated and what are they?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is $$$$?
How to update a particular record in target with out running whole workflow?