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 an expression transformation differs from aggregator transformation?
What is the benefit of partitioning a session?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain lookup transformation is active in informatica
What is exclusive and normal mode for repository services?
What is data movement mode in Informatica and difference between them?
How many types of sessions are there in informatica.please explain them?
Define joiner transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Why do you use Mapping Parameter and mapping variable?
What do you mean by worklet?
What is data transformation manager process?
How do you set a varible in incremental aggregation
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.