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
- 29238 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 I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the differences between joiner transformation and source qualifier transformation?
Partition, what happens if the specified key range is shorter and longer
How to create a non-reusable instance of reusable transformations?
Define pmcmd command?
What is workflow monitor?
Enlist the tasks for which source qualifier transformation is used.
What do you mean by blocking transformation?
In which transformation you cannot drag ports into it?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
server hot-ws270 is connect to Repository B. What does it mean?
explain abt ur project architecture?
What are the new features of informatica 9.x in developer level?
What is dimensional table?
What is the difference between STOP and ABORT options in Workflow Monitor?
