Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
Answer Posted / joe
1. Use a sequence generator to associate a NEXTVAL to the
row.
2. Filter condition : NextVal <=20
For source- dbase: Do a filter at SQ by including the
following condition . WHERE Rownum <=20
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define enterprise data warehousing?
Explain incremental aggregation in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What do you mean incremental aggregation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is a node in Informatica?
Explain how to import oracle sequence into informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is sorter transformation?
How might one distinguish in the case of mapping is right or not without associating session?
generate date / time dimension in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
without table how to come first record only in oracle?
What are the different components of powercenter?