Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3234 Views
- QualTech, I also Faced
- E-Mail Answers
Answer / 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 |
Give the benefits of data integration suite?
how to load the data to fact table?
what are the reports developed in sap bw project and what is the requirement for developing it?
How we can see table structure?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is abap? What are idocs?
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 do you understand by the term ‘transformation’?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is the meant by Normalization and de-normalization?
What do you understand by active and passive transformations?
how to connect to a flatfile through ftp in informatica
Teradata 
