Informatica Interview Questions

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. informatica,datawarehousing,oracle,teradata)

1.hw the procedure will b here

2. wht type of question’s they will b asking.

3.In which area they concentrate more. since this is the first time im facing interview in UK. it will b a great help for me thanks to All in Advance
difference between stop and abort ?

How can we eliminate duplicate values from lookup without overriding SQL?

How to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2
s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

can v update d records in target using update strategy without generating primary key ?

suppose if we have duplicate records in a table temp n now i want to pass unique values to t1 n
duplicate values to t2 in single mapping? how

how do u use sequence created in oracle in informatica? Explain with simple example ?

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u
have load d data in 2 separate columns like ID should contain only numbers 1,2,3 n NAME col
should contain a,b,c in target? How

what is metadata?

what is dimension table?

what is fact table?

Which kind of index is preferred in DWH?

whether Sequence generater T/r uses Caches? then what type of Cache it is

what is shared Cache. when we will use shared Cache?

explain different types of modeling.

how u know when to use a static cache and dynamic cache in lookup transformation.

Explain about HLD and LLD ?

for ex: in source 10 records are there with column sal. use a filter transformation condition as
Sal=TRUE and connect to target. what will happen.

what is the tracing level? and difference between trace in normal and verbose and nonverbose?

I have flat file source. i want to load the maximum salary of each deptno into target. what is the
mapping flow

how much memory (size) occupied by a session at runtime

how DTM buffer size and buffer block size are related

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and
even no.of records into t2. what is the procedure and what t/r’s are involved and what is the
mapping flow

why cant we put a sequence generator or upd strategy transformation before joiner
transformation?

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and
explain about sessions.

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1?

What is a diff between joiner and lookup transformation ?

what is casual dimension?

Without using any transformations how u can load the data into target?

What is the difference between View and Materialized View ?

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location, to do
this we can use filter transformation, that logic is same for relation table and flat file table?

Why we need to use unconnected transformation?

What is incremental aggregation and how it is done?

How could we generate the sequence of key values without using sequence generator
transformation in the target ?

How do we come to know the Source data/file is ready/Updated in the source location, when the
session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session,
when the source is updated in source location without any time constraint?

how do u move the code from development to production?

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2
and 1,x and 1,y and 2,a and 2,b, what is the procedure?

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my
target out of which 5 are updated rows how can I send them to target? How can I insert and
update the record?

What is the method of loading 5 flat files of having same structure to a single target and which
transformations I can use?

In a scenario I want to change the dimensions of a table and normalize the denormalized table
which transformation can I use?

Why is meant by direct and indirect loading options in sessions?

what is the logic will you implement to load data into a fact table from n dimension tables?

I have 1200 records how can u send it in aggregator with good performance issues?

Flat file heaving 1 lack records and I want to push 52000 records to the target? How will u pas
the data with out debugger?

How will u find weather dimension table is big in size of a fact table?

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit
first?

explain the scenario for bulk loading and the normal loading option in Informatica Work flow
manager ?

What is Factless fact table ?

Can any body tell about the (UTC) unit test cases with the examples in informatica.

What’s the difference between $, $$, $$$

From where we can start or use pmcmd?

In real time scenario where can we use mapping parameters and variables?

By using Filter Transformation, How to pass rows that does not satisfy the condition(discarded
rows) to another target?

THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO ONE FORMAT
WITHOUT USING EXPRESSION TRANSFORMATION ?

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN
PLACE OF THAT NULL VALUE IN TARGET .?

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT
COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

two tables from two different databases r there . both having same structure but different data .
how to compare these two tables ?

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U
JOIN THESE TWO USING JOINER TRANSFORMATION ?

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

1)can anyone explain how to use Normalizer transformation for the following scenario Source
table Target Table Std_name ENG MAT ART Subject Ramesh Himesh Mahesh Ramesh 68
82 78 ENG 68 73 81 Himesh 73 87 89 MAT 82 87 79 Mahesh 81 79 64 ART 78 89 64 please explain what should be the normalizer column(s) The GCID column

2)Also please explain the Ni-or-1 rule.

Could any one to tell Fact table Partitioning?

Could any one to tell How to use the Oracle Analytic functions in Informatica?

WHAT IS FACT TABLES?

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the
three dimensions by using one sequence generator is possible? If the mapping is containing
single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions
then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE
OVERRIDE ?

HOW DO YOU CONNECT TO REMOTE SERVER ?

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT ,
UPDATE OPRATION ?

HOW DO YOU PARFORM INCREMENTAL LAOD ?

what are the reusable tasks in informatica ?

suppose a session is failed after a transformation , from where that session will run again , i.e .
from beginning or from that transformation ?

what is the function of ‘F10′ informatica ?

HOW TO GET THE LATEST DATA IN SCD ?

two types of data are there . one is mainframe and the other is ascii format . in informatica how
can you get both the data in a single format in ascii .

in unconnected lookup , what are the other transformations , that can be used in place of that
expression transformation ?

what are the transformations that are used in data cleansing ? and how data cleansing takes
place ?

Generally how many Fact Tables and Dimensions Table you have used in the Project?

Which one is loaded first Fact Table or Dimensions Table into the warehouse?

What is the size of the Fact

Table and Dimension Table?

what is the size of the table and warehouse

Is Flat File Contains the Dynamic Cache?

what is data driven?

what are the transformations that are not involved in mapplet?

What are differences between Informatica 7.1 and 6.1 ?

Can you use one mapping to populate two tables in different schemas ?

How do you take care of security using a repository manager ?

if the session fails after 100 records again we have to starts the session or we go for recovery
session ?

How the server recognizes , if the session fails after loading the 100 records in to the target ?

we have a parameter file in Unix location where we have .txt files and those file will be used as
source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

what is the difference between onsite & client site?

what is scd?

connected and unconnected lookups?

what happens when a batch fails?

what is parallel querying and what are hints.?

What are the values that are passed between informatics server and stored procedure?

version controlling in informatica?

surrogate keys usage in Oracle and Informatica?

star and snowflake schema?

Kimball and Inmon methodologies?

what is confirmed dimension?

How do you move the code from development to production?

why do you use shortcuts in informatica.?

If you have 10 mappings designed and you need to implement some changes (may be in existing
mapping or new mapping need to be designed) then how much time it takes from easier to
complex?

What is the filename which you need to configure in UNIX while installing infromatica?

What happens if you increase commit intervals and also decrease commitExplain grouped cross
tab?

What is hash partition?

What is the approximate size of data warehouse?

What is data quality? How can a data quality solution be implemented into my informatica
transformations, even internationally?

What is the difference between view and materialised view?

How is Data Models Used in Practice?

What is an MDDB? What is the difference between MDDBs and RDBMSs?

What is active and passive transformation?

Why do we use DSS database for OLAP tools?

What is up date strategy and what are the options for update strategy?

What is data merging, data cleansing and sampling?

What is staging area?

What is difference between a connected look up and unconnected look up?

What is a look up function? What is default transformation for the look up function?

What is query panel?

How can you define a transformation? What are different types of transformations in
Informatica?

What is hash partition?

Which kind of index is preferred in DWH?

What is power play plug in?

What is Cognos script editor?

What is IQD file?

What is the Difference between PowerPlay transformer and power play reports?

What is the capacity of power cube?

What is confirmed dimension?

What is meta data and system catalog?

What is operational data source (ODS)?

What are the Advantages of de normalized data?

After dragging the ports of three sources(sql server, oracle, informix) to a single source qualifier,
can you map these three ports directly to target?

If i done any modifications for my table in back end does it reflect in informatca warehouse or
maping desginer or source analyzer?

What are the circumstances that infromatica server results an unreciverable session?

How can you complete unrecoverable sessions?

How can you recover the session in sequential batches?

How to recover the standalone session?

If a session fails after loading of 10,000 records in to the target. How can you load the records
from 10001 th record when u run the session next time?

Explain about Recovering sessions?

What is difference between stored procedure transformation and external procedure
transformation?

What are the scheduling options to run a session?

what is incremental aggregation?

What are the new features in Informatica 5.0?

How can u work with remote database in informatica? did you work directly by using remote
connections?

What is power center repository?

What is Performance tuning in Informatica?

what are the transformations that restricts the partitioning of sessions?

What is difference between partitioning of relational target and partitioning of file targets?

How can you access the remote source into your session?

What is parameter file?

What are the session parameters?

How can u stop a batch?

Can you start a session inside a batch individually?

Can you start a batches with in a batch?

In a sequential batch can u run the session if previous session fails?

What are the different options used to configure the sequential batches?

What is a command that used to run a batch?

When the informatica server marks that a batch is failed?

How many number of sessions that u can create in a batch?

Can you copy the batches?

What is batch and describe about types of batches?

Can you copy the session to a different folder or repository?

What is polling?

In which circumstances that informatica server creates Reject files?

What are the out put files that the informatica server creates during the session running?

What are the data movement modes in informatcia?

What are the different threads in DTM process?

What is DTM process?

What are the tasks that Loadmanger process will do?

Why you use repository connectivity?

How the informatica server increases the session performance through partitioning the source?

To achieve the session partition what are the necessary tasks u have to do?

Why we use partitioning the session in informatica?

Which tool you use to create and manage sessions and batches and to monitor and stop the informaticaserver?

Define maping and sessions?

What is metadata reporter?

What are the new features of the server manager in the informatica 5.0?

What are two types of processes that informatica runs the session?

How can you recognise whether or not the newly added rows in the source r gets insert in the
target ?

What are the different types of Type2 dimension maping?

What are the mapings that we use for slowly changing dimension table?

What are the types of maping in Getting Started Wizard?

What are the types of maping wizards that r to be provided in Informatica?

What are the options in the target session of update strategy transsformatioin?

What is Datadriven?

What is the default source option for update stratgey transformation?

Describe two levels in which update strategy transformation sets?

what is update strategy transformation ?

What are the basic needs to join two sources in a source qualifier?

What is the default join that source qualifier provides?

What is the target load order?

What are the tasks that source qualifier performs?

What is source qualifier transformation?

What is the status code?

What are the types of data that passes between informatica server and stored procedure?

Why we use stored procedure transformation?

What are the types of groups in Router transformation?

What is the Router transformation?

What is the Rankindex in Ranktransformation?

What are the rank caches?

How the informatica server sorts the string values in Rank transformation?

Which transformation should we use to normalize the COBOL and relational sources?

What are the Differences between static cache and dynamic cache?

What are the types of lookup caches?

what is meant by lookup caches?

What are the Differences between connected and unconnected lookup?

What are the types of lookup?

Why use the lookup transformation ?

what is the look up transformation?

What are the joiner caches?

What are the join types in joiner transformation?

what are the settings that u use to configure the joiner transformation?

In which conditions we can not use joiner transformation (Limitations of joiner transformation) ?

What are the differences between joiner transformation and source qualifier transformation?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?

What are the mapping paramaters and mapping variables?

What are the unsupported repository objects for a mapplet?

What are the methods for creating reusable transforamtions?

What are the reusable transformations?

How many ways you create ports?

What are the connected or unconnected transformations?

What are the active and passive transformations?

What are the designer tools for creating transformations?

what is a transformation?

How can you create or import flat file definition in to the warehouse designer?

Which transformation should u need while using the cobol sources as source defintions?

To provide support for Mainframes source data, which files r used as a COBOL files

Where should you place the flat file to import the flat file definition to the designer?

How many ways you can update a relational source definition and what are they?

While importing the relational source definition from database, what are the meta data of source
you import?

Explain reference cursor?

What is aggregate awareness?

What is difference between Mapplet and reusable transformation?

What is surrogate key?

How many repositories can we create in Informatica?

What is the Hierarchy of DWH?

Explain grouped cross tab?

What is the Difference between DSS & OLTP?

What is source qualifier?

What are mapping parametres and variables in informatica?

what are presession,postsession success and postsession failure commands ?

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase
the performance?

When do we use dynamic cache and static cache in connected and unconnected lookup
transformations?

What are the different threads in DTM process?

How to enter same record twice in the target table,explain?

What are the different types of schemas?

If session fails after loading 10000 records in the target,how can we load 10001 th record when
we run the session in the nexttime?

What is facttable granularity?

What are reusable transformations in how many ways we can create them?

What is confirmed dimension and fact?

What are the two modes of datamovement in informatica sever?

What is status code?

What is the difference between OLTP and ODS?

What are slowly changing dimensions?

AT the max how many transformations and mapplets can we use in a mapping ?

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we
map these ports directly to target and how?

How can we eliminate duplicate rows from flatfile,explain?

If we have lookup table in workflow how do you trouble shhot to increase performance?

can we generate reports in informatica ? How?

What are limitations of joiner transformation?

How can we join the tables if they don’t have primary and foreign key relationship and no
matching port?

Name 4 output files that informatica server creates during session running?

What is the functionality of update strategy?

What are teh different tasks that can be created in workflow manager?

What are the new features of informatica 7.1?

Explain the flow of data in Iinformatica?

Explain one complecated mapping?

what are the real time problems generally come up while doing or running mapping or any
transformation?

What is exact use of ‘Online’ and ‘Offline’ server connect Options while defining Work flow in
Work flow ?

what is the logic will you implement to laod the data in to one factv from ‘n’ number of
dimension?

what is the difference between Informatica 7.1 and Abinitio?

What is Micro Strategy? Why is it used for?

what is the difference between stop and abort?

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

what are cost based and rule based approaches and what is the difference?

what is mystery dimension?

Explain about the concept of mapping parameters and variables ?

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

Can you generate reports in Informatcia?

What are the different types of Type2 dimension maping?

What are the types of maping in Getting Started Wizard?

What are the out put files that the informatica server creates during the session running?

What are the data movement modes in informatcia?

What is difference between maplet and reusable transformation?

How to recover the standalone session?

If you done any modifications for a table in back end does it reflect in informatca warehouse or
maping?

How to recover sessions in concurrent batches?

Explain about perform recovery?

If a session fails after loading of 10,000 records in to the target. How can you load the records
from 10001?

Why we use lookup transformations?

What are Dimensions and various types of Dimensions?

What is Code Page Compatibility?

What are Target Options on the Servers?

What is tracing level and what are the types of tracing level?

What are the types of metadata that stores in repository?

Define informatica repository?

In a sequential batch can you run the session if previous session fails?

What is a command that used to run a batch?

When the informatica server marks that a batch is failed?

Can you copy the session to a different folder or repository?

In which circumstances that informatica server creates Reject files?

What are the basic needs to join two sources in a source qualifier?

What is aggregate cache in aggregator transformation?

What are the reusable transformations?

what is a time dimension? give an example?

Discuss the advantages & Disadvantages of star & snowflake schema?

What is the difference between Normal load and Bulk load?

what is a junk dimension ?

What is the procedure to load the fact table. Give in detail?

What is the use of incremental aggregation?

why dimension tables are denormalized in nature ?

What is the difference between Power Centre and Power Mart?

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

what is the exact meaning of domain?

How do you handle decimal places while importing a flatfile into informatica?

What is IQD file?

What is data merging,data cleansing,sampling?

How to import oracle sequence into Informatica?

what is worklet and what use of worklet and in which situation we can use it?

what is difference between dimension table and fact table?

what is polling?

what happens if you try to create a shortcut to a non- shared folder?

If you want to create indexes after the load process which transformation you choose?

Where is the cache stored in informatica?

what is Partitioning ? where we can use Partition?

what are the different types of transformation available in informatica and what are the mostly
used ?

How to recover sessions in concurrent batches?

what is the gap analysis?

what is difference between COM & DCOM?

How to view and Generate Metadata Reports?

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

What is critical mapping?

How to improve the performance of Aggregate transformation?

Why to use stored procedure in ETL Application?

How do you create single lookup transformation using multiple tables?

In update strategy target table or flat file which gives more performance ? why?

How to load time dimension?

what is the flow?

what is lookup ?

4 Response to "Informatica Interview Questions"

  1. Anonymous says:

    where r the answers????

    Anonymous says:

    i guess one has to write a book to answere these questions

    dante says:

    Hi

    Tks very much for post:

    I like it and hope that you continue posting.

    Let me show other source that may be good for community.

    Source: Warehouse interview questions

    Best rgs
    David

    Anonymous says:

    Answers please.. would be helpful indeed

Post a Comment

Powered by Blogger