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
- 29386 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 various types of transformations.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is event and what are the tasks related to it?
What is data movement mode in Informatica and difference between them?
How many types of sessions are there in informatica.please explain them?
Explain the types of lookup transformation?
Describe an informatica powercenter?
How can one identify whether mapping is correct or not without connecting session?
What is informatica powercenter repository?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the guidelines to be followed while using union transformation?
What is the way to execute pl/sql script using informatica mapping?
What is data caches/ index caches?
Can u generate reports in Informatica?
