Interested to Buy Any Domain ? << Click Here >> for more details...
Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 11099 Views
- Flextronics, I also Faced
- E-Mail Answers
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
what is degenerated dimension?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Difference between Target-based loading and constraint-based loading?
Under what condition selecting sorted input in aggregator may fail the session?
What are the different lookup cache(s)?
What are the differences between source qualifier and joiner transformation?
What are the features of complex mapping?
What are the uses of etl tools?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to implement security measures using repository manager?
How you can differentiate between connected lookup and unconnected lookup?
Define update strategy?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Mention some types of transformation?
