how can we load first and last record from a flat file
source to target?
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
How to start a workflow using pmcmd command?
Plz can any one say me how to get the informatica certification materials and dumps
Explain in detail about scd type 1 through mapping.
What are the main issues while working with flat files as source and as targets ?
draw informatica architecture 8.6 ?
How to generate sequence numbers?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are connected or unconnected transformations?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
On which transformations you created partitions in your project?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to improve the performance of a session using sorter transformation?
How many dimensions are there in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How will the document be delivered to me?