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 |
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What is PX?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Can you highlight the main features of ibm infosphere information server?
What is difference between join, merge and lookup stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
what is factless fact table?
Describe link sort?
Define meta stage?
How can we do null handling in sequential files?