top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

how can manage data from datawarehouse

+1 vote
279 views

how can manage data from datawarehouse

posted Jul 16, 2013 by Madhuri Bhushan

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

If we take control the following 5 points then we can say data from DWH is managed properly.

  • How can I ensure that my data warehouse is constantly available to its users?
  • What happens if the operating system, or disk, or database crashes? – Or the site gets burned down?
  • How can I tune the system on the fly?
    – In fact, how can I change the hardware configuration on the fly?
  • How can I spread the performance load across my global wide-area network?
  • How do I manage such an enormous amount of online and offline critical data?
answer Jul 16, 2013 by anonymous
Similar Questions
+1 vote

use of datawarehouse.

+1 vote

How can I pivot row data using Informatica PowerCenter Designer? Say, I have a source file called address.txt:

+---------+--------------+-----------------+
| ADDR_ID |     NAME     |     ADDRESS     |
+---------+--------------+-----------------+
|       1 | John Smith   | JohnsAddress1   |
|       1 | John Smith   | JohnsAddress2   |
|       2 | Adrian Smith | AdriansAddress1 |
|       2 | Adrian Smith | AdriansAddress2 |
+---------+--------------+-----------------+

I would like to Pivot this data like this:

+---------+--------------+-----------------+-----------------+
| ADDR_ID |     NAME     |    ADDRESS1     |    ADDRESS2     |
+---------+--------------+-----------------+-----------------+
|       1 | John Smith   | JohnsAddress1   | JohnsAddress2   |
|       2 | Adrian Smith | AdriansAddress1 | AdriansAddress2 |
+---------+--------------+-----------------+-----------------+

How can I do this in Informatica?

...