what is the definitions for Datawarehose and Datamart?
Answer Posted / sagar
Datamart is subset of Datawarehouse we can say ....a
datamart is collection of individual departmental
information...
Where as datawarehouse in collection of datamart.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Differentiate between datastage and datastage tx?
How to convert RGB Value to Hexadecimal values in datastage?
What is meta stage?
Difference between sequential file and data set?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
AGGREGATOR default datatype
What are the different kinds of views available in a datastage director?
What is difference between join, merge and lookup stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How do you remove duplicate values in datastage?
What all the types of jobs you developed?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
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?
Explain the situation where you have applied SCD in your project?
Difference between server jobs & parallel jobs?