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
- 29197 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi,,, Vinod, As per your Solution we have to check
complete data Table for ,,
syntax for 1st,last:::
FIRST( ITEM_NAME, ITEM_PRICE > 40 )
FLOOR( PRICE )
ok,,,
Any corrections Let me Know,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
what is the complex transformation you used in informatica
Whats there in global repository
What are the main issues while working with flat files as source and as targets ?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to improve the performance of a session using sorter transformation?
can we override a native sql query within informatica? Where do we do it?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the issues you have faced in your project? How did you overcome those issues?
wat are deployement groups in informatica, how it will be used for developers
Explain sessions and how many types of sessions are there?
can anyone suggest best free Talend data integration training online
Why update strategy and union transformations are active?
What is a dimensional model?
How to create a non-reusable instance of reusable transformations?
