Interested to Buy Any Domain ? << Click Here >> for more details...
What is the need of building a data warehouse?
- 2 Answers
- 4941 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 |
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What is substr in informatica?
What do you understand by term role-playing dimension?
what are the different types of transformation available in informatica and what are the mostly used ?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
Which is the best place to learn Informatica Powercenter Online Training?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What are the conditions needed to improve the performance of informatica aggregator transformation?
Teradata 
