how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer Posted / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various tools used in etl?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What are cubes and olap cubes?
What is the difference between Data Warehousing and Data Mining?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is a materialized view log?
what is the use of server manager?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the use of server?
what is the difference steps for data modeling?
what is an ETL or ETT? And what are the different types?
What is a staging area? What is the purpose of a staging area?