Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
Answer Posted / sunny
Hello joe, your solution is partially correct - what if the
records are not in sequence to do MAX minus 20 ? I guess
this logic can be applied only after passing through
sequence generator, by getting a sequence number.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
What is a predefined event?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the use of target designer?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load a Dimension ? and how to load a fact table?
What is the benefit of partitioning a session?
Define the various join types of joiner transformation?
What is exclusive and normal mode for repository services?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
explain about unit testing? in real time?
what is unit testing?tell me proceedure
How to join three sources using joiner?
What are the uses of etl tools?