Explain etl mapping sheets?
No Answer is Posted For this Question
Be the First to Post Answer
what are the facilities provided by OLAP to analytical users?
Explain 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.?
Explain me ETL project architecture in Detail?
what is the indicator file and where it is used?
Explain do we need an etl tool? When do we go for the tools in the market?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Identifying the bottlenecks in various components of Informatica and resolving them.
what is Forward,Reverse and Re_engineering?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what do u do when DB time takes more?in sap bi
Can u access a repository created in previous version of Informatica?