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
- 29159 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
What are the issues you have faced in your project? How did you overcome those issues?
What is session task and command task?
What is union transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Design a mapping to load a target table with the following values from the above source?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is fact table? Explain the different kinds of facts.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is joiner transformation in informatica?
What are the different ways to implement parallel processing in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
without table how to come first record only in oracle?
waht type of interface is used for testing the data in informatica
According to his methodology what all you need before you build a datawarehouse
