What are the challenges of Dataware housing in the future?
- 2 Answers
- 7292 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.
| Is This Answer Correct ? | 2 Yes | 0 No |
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
How can we use batches?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
What are the types of maping in Getting Started Wizard?
Does an informatica transformation support only aggregate expressions?
What is polling?
Explian the Process of deployment groups in informatica
Why we require dwh in particular projects?
How you prepared reports for OLAP?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
Teradata 
