how can we load first and last record from a flat file
source to target?
Answer Posted / hardeep
We can use below configurations to achieve desired output. We need 1 SQ, 1 SGen, 2 Rank and 2 Trgt Defn(same Trt). I think it will be cheaper.
Src-SQualifier-->
|
Rank1(Top 1st) -->Trgt1
--->
Rank2(Bottom 1st) -->Trgt2
|
SGen(NEXTVAL)-->
Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a joiner transformation and why it is an active one?
Different sorts of metadata that stores in the storage facility?
Design a mapping to load a target table with the following values from the above source?
What are multi-group transformations?
What is a repository manager?
What is the difference between stop and abort in informatica
Which is the t/r that builts only single cache memory?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is aggregator transformation in informatica?
What are the differences between oltp and olap?
Mention some types of transformation?
How to load last n records of file into target table - informatica
What is different between the data warehouse and data mart?
Please let me know how to make encryption and decryption with example?