TOP Informatica Interview Questions and Answers
What is target load order?
Target load order is specified on the basis of source qualifiers in a mapping. If there are multifold source qualifiers linked to different targets then one can entitle order in which informatica server loads data into targets.
Where can we find the throughput option in informatica?
Throughput option can be found in informatica in workflow monitor. In workflow monitor, right click on session, then click on get run properties and under source/target statistics we can find throughput option.
What is the use of target designer?
Target Definition is created with the help of target designer.
What do you mean by worklet?
When the workflow tasks are grouped in a set, it is called as worklet. Workflow tasks includes timer, decision, command, event wait, mail, session, link, assignment, control etc.
What are the different types of OLAP? Give an example?
ROLAP eg.BO, MOLAP eg.Cognos, HOLAP, DOLAP
What is OLAP (On-Line Analytical Processing?
A method by which multi-dimensional analysis occurs.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
The tool for scheduling purpose other than workflow manager can be a third party tool like ‘CONTROL M’.
What are the different tools in workflow manager?
Following are the different tools in workflow manager namely
- Task Designer
- Task Developer
- Workflow Designer
What is a work flow?
Work flow is a bunch of instructions that communicates server about how to implement tasks.
How can you define user defied event?
User defined event can be described as a flow of tasks in the workflow. Events can be created and then raised as need arises.
What is predefined event?
It is a file-watch event. It waits for a specific file to arrive at a specific location.
What is meant by pre and post session shell command?
Command task can be called as the pre or post session shell command for a session task. One can run it as pre-session command r post session success command or post session failure command.
What is standalone command task?
This task can be used anywhere in the workflow to run the shell commands.
What does command task mean?
This specific task permits one or more than one shell commands in UNIX or DOS in windows to run during the workflow.
Briefly define a session task?
It is a chunk of instruction the guides Power center server about how and when to transfer data from sources to targets.
Which files are created during the session rums by informatics server?
During session runs, the files created are namely Errors log, Bad file, Workflow low and session log.
What are the prerequisite tasks to achieve the session partition?
In order to perform session partition one need to configure the session to partition source data and then installing the Informatica server machine in multifold CPU’s.
What is surrogate key?
Surrogate key is a replacement for the natural prime key. It is a unique identification for each row in the table. It is very beneficial because the natural primary key can change which eventually makes update more difficult. They are always used in form of a digit or integer.
What is the scenario which compels informatica server to reject files?
This happens when it faces DD_Reject in update strategy transformation. Moreover it disrupts the database constraint filed in the rows was condensed.
What does update strategy mean, and what are the different option of it?
Row by row processing is done by informatica. Every row is inserted in the target table because it is marked as default. Update strategy is used whenever the row has to be updated or inserted based on some sequence. Moreover the condition must be specified in update strategy for the processed row to be marked as updated or inserted.