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 is union transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How many input parameters can exist in an unconnected lookup?
Is there any way to read the ms excel datas directly into informatica?
What is the need of etl tools?
tell me 5 session failure in real time how can you solve that in your project?
Can you use flat files in Mapplets.
What is the use of an aggregator cache file?
What does role playing dimension mean?
How to create or import flat file definition in to the warehouse designer?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What do you mean by filter transformation?
define galaxy repository in informatica
How do you migrate data from one environment to another?
Briefly explain the aggregator transformation?