Interested to Buy Any Domain ? << Click Here >> for more details...
What is the need of building a data warehouse?
- 2 Answers
- 4785 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 passive transformation?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Major difference between SQL override and Lookup Sql override
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Where is metadata stored?
how to run the batch using pmcmd command
Explain informatica architecture - version 8 / 9
What are the types of metadata that stores in repository?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
All active transformations r passive or not?
Teradata 
