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 one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
Why we use lookup transformations?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What does update strategy mean, and what are the different option of it?
What is the need for an etl tool?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What does reusable transformation mean?
What are the new features of the server manager in the informatica 5.0?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
In development project what is the process to follow for an etl developer from day1