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
- 8535 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?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What do you understand by active and passive transformations?
Explain about power designer data modeling software?
how do u set partition points in the mapping?
Explain do we need an etl tool? When do we go for the tools in the market?
Compare etl & elt?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is the difference steps for data modeling?
how to load the data to fact table?
What is full load & incremental or refresh load?
What are materialized views & where do we use them?
where we cannot use sorter Transformation. if we use then we will not get correct data?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is data cleaning?
