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
whats the logic to load the lower level of granularity of data to fact table.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is a code page?
Name the different lookup cache(s)?
What is domain and gateway node?
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 can we use batches?
What is a joiner transformation?
How do you load alternate records into different tables through mapping flow?
Briefly describe lookup transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Explain pmcmd command usage in informatica
How big was your fact table
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?