What are the main features of Oracle 8i with context to datawarehouse?
No Answer is Posted For this Question
Be the First to Post Answer
What is operational data source (ODS)?
how can we calculate fact table size?
How do you convert single row from source into three rows into target?
While migrating the data from one environment to another environment how would you manage the connections?
What is confirmed dimension and fact?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
scenario
performance tuning of Informatica
How to view and Generate Metadata Reports?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
star and snowflake schema?