Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 4 Answers
- 8675 Views
- I also Faced
- E-Mail Answers
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
Explain about hash partitioning?
how to connect to a flatfile through ftp in informatica
What are three tier systems in etl?
What is initial load and what is full load?
What is tracing level?
what are the production issues in datastage?
can be used COM component in Informatica ?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
how many steps are there in etl process?
Do we need an ETL tool? When do we go for the tools in the market?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is partitioning? Explain about round-robin, hash partitioning.
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is a staging area? What is the purpose of a staging area?
what is the meant by Normalization and de-normalization?
