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
- 29460 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
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
where to store informatica rejected data?
How can we use mapping variables in informatica? Where do we use them?
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.
How you prepared reports for OLAP?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you migrate data from one environment to another?
What do you mean incremental aggregation?
What is joiner transformation?
How can we create index after completion of load process?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Differentiate between joiner and lookup transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What do you understand by term role-playing dimension?
explain abt ur project architecture?
How you can differentiate between connected lookup and unconnected lookup?
