Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

How to improve the session performance in informatica?

Accenture,

3 21381

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1938

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

3 7903

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

2 6295

what is curr val use for in sequence generator?

Emphasis,

2 7401

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

1 4757

what is the necessity to use update strategy?(except for updates)

Emphasis,

2 6249

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,

2 10164

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Accenture,

6 11631

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

TCS,

1 5712

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 8993

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 10836

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 8952

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 6403

What are the issues you have faced in your project? How did you overcome those issues?

CTS, FEEE, TCS,

2308

Post New Informatica Questions

Un-Answered Questions { Informatica }

Differences between version 7.x and 8.x.

1858

Where is metadata stored?

1059

What is the different lookup cache(s)?

1048

can you please explain me pre session and post session options?

7451

hi real timers . iam waiting for ur reply regarding ETL TESTING

2218

Write the unconnected lookup syntax?

1051

Mention few advantages of router transformation over filter transformation.

994

What are the settings that you use to configure the joiner transformation?

1018

What are the different types of transformation available in informatica.

1046

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2201

Enlist the various types of transformations.

976

What is dimensional table? Explain the different dimensions.

1126

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1047

What is the need of an ETL tool?

1046

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4692

For More Un-Answered { Informatica } Questions Click Here