1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how can we load first and last record from a flat file
source to target?

Question Posted / hardeep

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


Please Help Members By Posting Answers For Below Questions

Explain the different lookup methods used in informatica?

590

Quickly characterize reusable change?

694

Make a note of the quantity vaults made in informatica?

561

Can u generate reports in Informatica?

659

What is DR strategy for Informatica project?

706




How identifying bottlenecks in various components of informatica and resolving them?

587

Explain pushdown optimization and types in informatica

672

Define joiner transformation?

598

How to load last n records of file into target table - informatica

600

What is the use of an aggregator cache file?

693

What are the advantages of informatica?

576

What is an Integration service in Informatica?

706

What is sorter transformation?

587

What is an unconnected transformation?

667

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7772