how can we load first and last record from a flat file
source to target?
- 7 Answers
- 28288 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 is the size of u r source(like file or table)?
How can you differentiate between powercenter and power map?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is joiner change?
Explain the code page compatibility?
How to generate sequence numbers?
Design a mapping to load a target table with the following values from the above source?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to join three sources using joiner?
What is meant by pre and post session shell command?
What is the difference between writing a joiner query in ANSI style and THETA style?
How many transformations can be used in mapplets.
Is it possible to create multiple domains on a single Informatica server?
