Interested to Buy Any Domain ? << Click Here >> for more details...
What is the need of building a data warehouse?
- 2 Answers
- 4698 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish goel
Data warehouse is generally designed for analyzing the
business operations but not to run the business operations.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vas.chiky
Having separate OLAP DWH database for analysis, increases
the performance of reports.
even during backup or crash period of oltp, OLAP database
will not get affected.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a transaction control transformation?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
generate date / time dimension in informatica
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What is mapplet in informatica?
Can you use flat files in Mapplets.
How can we remove the duplicates from flat file source?
What is rank transformation in informatica
What is the benefit of session partitioning?
What is staging area?
Teradata 
