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
- 11304 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
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you use reject loader.
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain scd type 3 through mapping.
is it possible to index the data in cache of lkp transformation ?
What is rank transform?
Can we create a Integration service without a Repository service and vice versa?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the mapping variable usage example in informatica
COM components can be used in Informatica
What is DR strategy for Informatica project?
What are the new features of informatica 9.x developer?
pmscmd startworkflow -sv
