What is the need of building a data warehouse?
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 |
If you want to create indexes after the load process which transformation you choose?
How to handle decimal places while importing a flatfile into informatica?
whats the logic to load the lower level of granularity of data to fact table.
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
we have to use order by,where,having we to implement sql query
when will we go for unconnected lookup transformation in Informatica?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What is sequence generator transformation in informatica?
To achieve the session partition what r the necessary tasks u have to do?
How to handle changing source file counts in a mapping?