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...
- 2 Answers
- 6832 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is active and passive stage?
What is difference between symmetric multiprocessing and massive parallel processing?
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 are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the difference between datastage and datastage tx?
What are the main features of datastage?
table actions available in oracle connector?
What are stage variables and constants?
Have you used Unstructured data?
What all are the different way to run a job?
Differentiate between datastage and informatica?
What is the difference between server job and parallel jobs?
CHANGE CAPTURE
Describe the architecture of datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
