Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 6297

what is the architecture of any Data warehousing project?

IBM,

4 10147

what is the flow?

1 2995




How to load time dimension?

Ford,

1 8665

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

7 13712

How do you create single lookup transformation using multiple tables?

TCS,

6 23990

Why touse stored procedure in ETL Application?

2 6112

How to improve the performance of Aggregate transformation?

Dmss,

3 7185




What is critical mapping?

2 5429

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

Accenture,

1 11906

How to view and Generate Metadata Reports?

1 3554

what is difference between COM & DCOM?

Satyam,

1 6945

what is the gap analysis?

1 5166

How to recover sessions in concurrent batches?

3 9114

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

TCS,

3 16695


Post New Informatica Questions






Un-Answered Questions { Informatica }

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

527


my source is junk data how will u remove that junk data by using unix please any one replay me

2213


why we are using level option in normalizer transformation

4214


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

970


The question was on time stamp. what is the difference between HH and HH24 when to use when.

338


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

632


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

153


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

951


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

615


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

987


Whats there in global repository

307


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

153


how we can load rejected record's at run time?(not through bad files)

732


Design time, run time. If you don't create parameter what will happen

447


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

649