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 |
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the various kinds of the hash file?
Where do the datastage jobs get stored?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the roundrobin collector?
What is RCP?
How a routine is called in datastage job?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu