Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 6297

what is the architecture of any Data warehousing project?


4 10147

what is the flow?

1 2995

How to load time dimension?


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?


6 23990

Why touse stored procedure in ETL Application?

2 6112

How to improve the performance of Aggregate transformation?


3 7185

What is critical mapping?

2 5429

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


1 11906

How to view and Generate Metadata Reports?

1 3554

what is difference between COM & DCOM?


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 ?


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?


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


why we are using level option in normalizer transformation


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


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


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


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


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


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


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


Whats there in global repository


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?


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


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


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. ?