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...

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


Please Help Members By Posting Answers For Below Questions

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2182


What is the different type of jobs in datastage?

575


why do u need the IOS upgradation in a FC switch

1875


What are the repository tables in datastage?

828


Why do we use link partitioner and link collector in datastage?

685






Difference between sequential file and data set?

645


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1702


What are the main features of datastage?

662


Differentiate between hash file and sequential file?

585


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2545


Explain entity, attribute and relationship in datastage?

635


describe the Steps to confiure a Qlogic switch

1939


What is the difference between orabulk and bcp stages?

576


How to RD using transformer?

864


What are some prerequisites for datastage?

617