how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
Is This Answer Correct ? | 0 Yes | 0 No |
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what is the difference between shortcut of an object and copy of an object? compare them?
What is granularity? Please explain with example
What is grain of fact?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
what is the use of structures?how many nodes can u create in a structure?
what is granularity in Data ware House?
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.?
what is session partitioning?
What is etl process. How many steps etl contains explain with example?
how does the server recongnise the source and target databases.Elaborate on this