how can we load first and last record from a flat file
source to target?
- 7 Answers
- 28367 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
Enlist the tasks for which source qualifier transformation is used.
What are the advantages of using informatica as an etl tool over teradata?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
In warehouses how many schemas are there?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is native users?
What is the sequence generator transformation in informatica?
Briefly describe lookup transformation?
Explain what are the different versions of informatica?
What is rank transformation?
How to do unit testing in informatica? How to load data in informatica ?
What is repository manager?
What are data-driven sessions?
How to improve the performance of a session using sorter transformation?
What's the layout of parameter file (what does a parameter file contain?)?
