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
Tell me about MD5 functions in informatica
What is meant by active and passive transformation?
What is source qualifier transformation in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is confirmed fact in dataware housing?
What are the prerequisite tasks to achieve the session partition?
Explain sessions?
Different circumstance which drives informatica server to expel records?
How many ways are there to do 'remove duplicate records in informatica'?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
can we override a native sql query within informatica? How do we do it?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the difference between STOP and ABORT options in Workflow Monitor?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?