1)i put Pharma Project in my Resume..whar are the sources
used in my project Generally?
2)how many fact and dimensional tables used?
3)Have u used any Datamarts and measues in fact
table? ....plz give the answers...
Answers were Sorted based on User's Feedback
Answer / raam chowdary
i extract data from different sources like oracle,sap r/3,db2,flat files,terradata,mainframes..........
nearly 8fact tables
and 18dimension tables
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lokesh
only one fact table and Meany dimension tables
datamarts is subject oriented database
| Is This Answer Correct ? | 0 Yes | 2 No |
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
What are transforms and what is the differenece between routines and transforms?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is a quality stage?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
which cache supports connected & un connected Lookup
What is a merge in datastage?
is it possible to access the same job by two users at a time in DataStage?
which is the most complex job in your career? Please tell me answer?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How and where you used hash file?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?