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
What happens when a session fails and you click on recover?
How would you copy the content of one repository to another repository?
How do you use reject loader.
what are the deliverables?in your project?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Quickly characterize reusable change?
What is InformaticaPowerCenter?
Informatica settings are available in which file?
Explain why we use partitioning the session in informatica?
Why do we need informatica?
What is meant by active and passive transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what are factless facts? And in which scenario will you use such kinds of fact tables.
Why filter transformation is an active one?
What are the types of caches in lookup? Explain them.