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

Post New Answer

More Informatica Interview Questions

What is operational data source (ODS)?

7 Answers  


how can we calculate fact table size?

1 Answers  


How do you convert single row from source into three rows into target?

0 Answers  


While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


What is confirmed dimension and fact?

7 Answers  






Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,


scenario

1 Answers  


performance tuning of Informatica

1 Answers  


How to view and Generate Metadata Reports?

1 Answers  


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

3 Answers   IBM,


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


star and snowflake schema?

6 Answers  


Categories