Friday, January 11, 2013

OBIA - DAC Questions


In this post I will discuss some interview questions on Data Warehouse Administration Console (DAC) which checks the key concepts about tool.

 Here I will be discussing all about Oracle DAC or DAC which controls the execution of Informatica mappings.

1> Over all architecture of DAC ?
2> Why we should use DAC and not control all execution through informatica ?
3> Can we run multiple execution plan at the same time in DAC ?
4> Explain DAC export/import
5> Have you change any of the DAC parameters ? If so which one and why ?
6> How do you Determine the Informatica Server Maximum Sessions Parameter Setting in DAC?
7> Can dac send an email just in case of any failures ?
8> Can you execute the sql scrip through DAC ? If yes how ?
9> in DAC How you can disable table indexes before loading and enable the index once load is complete ?
10>Let say you are running the normal incremental load. But just for today you want to extract data from AP_INVOCIES_ALL from 12/12/2011? How you can achieve this ?
11>How DAC Determines the Order of Task Execution within an Execution Plan ?
12>What are Micro ETL Execution Plans ? How can you Build and run them ?
13>From you past experience – explain scenario where Micro ETL Execution Plans produced wrong results on reports?
14> Let say you can not use DAC scheduler to schedule you execution plan. What other options do you have ? How you can achieve this ?
15>Does DAC keeps track of refresh dates for all the source/target tables ?
16>Consider the scenario as below for task T1
Primary Source has not null last refresh date
Primary Target has null last refresh date
Will task T1 executes in full or incremental ?
17>Explain the upgrade/merge options for DAC 7.8.4 & below and new versions ?
18> Using DAC command line – write a script to check weather informatica services are up or not ?
19>Can we have two DAC server on the same machine ?
20>Explain briefly What kind of DAC Repository Objects Held in Source System Containers ?
21>What is Authentication file ? If you have dac client installed can you access DAC repository without Authentication file ?
22>Explain Index, Table and Task Actions in DAC ?
23>How DAC Handles Parameters at Runtime ?
24> How DAC Determines Tasks Required for any given subject area Subject Area ?
25>Difference between Homogeneous and Heterogeneous execution plans?