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
- 11345 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 SDLC way of code development?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the new features of informatica 9.x at the developer level?
How do you handle two sessions in Informatica
Do you find any difficulty while working with flat files as source and target?
What is pmcmd command?
Describe an informatica powercenter?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what is the Default Source Option For Update Strategy Transformation?
What is a surrogate key?
What is deployment group?
What is sorter transformation?
What is the scenario which compels informatica server to reject files?
What are the steps involved in the migration from older version to newer version of Informatica Server?
