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 |
How many types of sorting methods are available in datastage?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is a nodemap constraint
1)Source file contains one record, I want 100 records in target file.
How do y read Sequential file from job control?
What are the different types of lookups in datastage?
What is "fatal error/rdbms code 3996" error?
What r the existing server jobs in parallalism?
How can we do null handling in sequential files?
how to closeing records after 10,000 records come?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?