Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7699 Views
- iGate, I also Faced
- E-Mail 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 |
what is the diff between sequential file and fileset stages?
What is the difference between passive stage and active stage?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
Explain connectivity between datastage with datasources?
Why do we use link partitioner and link collector in datastage?
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
how to cleansing data
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
ename like ibm,tcs,hcl need display those records only how?
how do u capture duplicates through sort & transformer
What are the types of containers in datastage?
Teradata 
