how can we load first and last record from a flat file
source to target?
- 7 Answers
- 27049 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
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the restrictions of union transformation?
What is the difference between stop and abort in informatica
Is there any target staging area in informatica not staging area
What is the difference between STOP and ABORT options in Workflow Monitor?
can anyone suggest best free Talend data integration training online
What are the types of lookup transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to elaborate tracing level?
What do you understand by term role-playing dimension?
What are mapplets? How is it different from a Reusable Transformation?
Explain the difference between mapping parameter and mapping variable?
What is the commit type if you have a transaction control transformation in the mapping?
How to delete duplicate row using informatica?
What are the new features of informatica 9.x at the developer level?
