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
Mention few power centre client applications with their basic purpose?
What is meant by pre and post session shell command?
How to extract the informatica rejected data?
What is the advantage of informatica?
wf dont have integration severances how you can run?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is standalone command task?
Which files are created during the session rums by informatics server?
What is the commit type if you have a transaction control transformation in the mapping?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can anyone tell me the new features in Informatica 9 Version?
What is workflow? What are the components of workflow manager?
Explain sessions and how many types of sessions are there?
What can we do to improve the performance of informatica aggregator transformation?
Tell me about Propagate functions in informatica