we hava more than 1000 records. i have to select first 5
record, last 5 record and 5 records from middle of the source.
how can i do in oracle as well as in informetica??
Answer Posted / chanukya
have the sequence generator transformation in the mapping
whcih will give you the row numbers.
From there you can take watever rows you want. From 1 to
last or anything.
This wil help you.
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is tracing level and what are the types?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What are three tier systems in etl?
what is pmrep command?
What is etl process?
What are various etl tools in the market?
Explain do we need an etl tool? When do we go for the tools in the market?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
what is granularity in Data ware House?
What is tracing level?
List few etl bugs?
What is full load & incremental or refresh load?
what is pmrep command?
what is a worklet?