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
- 8613 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
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is data modeling?
What is the difference between round-robin partitioning and hash partitioning?
what is pmrep command?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how many maximum session supports to multiload in teradata ??
Explain me ETL project architecture in Detail?
what is dynamic insert?
what are the types in error loging?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the names of the layers in etl?
How can we use external procedural logic in informatica?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What are the different etl testing categories as per their function?
