Interested to Buy Any Domain ? << Click Here >> for more details...
sorce is a flatfile only 1st and last row should insert to
target how will u do?
- 2 Answers
- 9107 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / mike
well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row
correct me if i was wrong
| Is This Answer Correct ? | 1 Yes | 5 No |
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
In which circumstances that informatica server creates Reject files?
Target is zero file and how can you send the email?
What is joiner cache?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
how we do performence tuning in informatica
Why is sorter an active transformation?
Normalizer transformation is not involved in Mapplet.. why???
What are session parameters ? How do you set them?
What is dynamic cache?
Can we create two repositories on same database instance in oracle?
What is galaxy shema
Teradata 
