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
- 29658 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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Implementation methodology
How can we handle two sessions in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the shared cache and re-cache?
Explain informatica architecture - version 8 / 9
Under which circumstances, informatica server creates reject files?
What are the differences between a connected lookup and unconnected lookup?
What is union transformation in informatica?
What is the way to execute pl/sql script using informatica mapping?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Enlist the differences between database and data warehouse.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How can repository reports be accessed without sql or other transformations?
Slowly changing dimensions, types and where will you use them
