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
- 7752 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 usage of datastage with materialized views
How do u view log file for a particular job?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to transfer file from one system to another system in unix? which cmd to be use?
why do u need the IOS upgradation in a FC switch
what is sparse lookup?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
How do you generate sequence number in datastage?
What are the partitioning techniques available in link partitioner?
What are the steps needed to create a simple basic datastage job?
whom do you report?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
Teradata 
