what is the use of server manager?
Answer / Kavendra Singh Sagar
Server Manager in ETL context is a graphical user interface (GUI) tool that provides an easy-to-use console for managing PowerCenter servers and workflows. It allows users to create, schedule, monitor, and manage data integration tasks.
| Is This Answer Correct ? | 0 Yes | 0 No |
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?
What are dimensions?
What is granularity? Please explain with example
how do u automate Extraction process?
how do u identify the changed records in operational data?
what is pmrep command?
how would u estimate the size of Aggregator transform data and index cache?
when will use SQL override in a lookup transformation?
What are your responsibilities as an etl tester?
what are the session parameters? How do u set them?
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.?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com