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 21383

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

1940

,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 7906

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 6297

what is curr val use for in sequence generator?

Emphasis,

2 7406

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 4759

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

Emphasis,

2 6251

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 11642

-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 5715

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 10840

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 6406

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 }

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

1940

Please let me know how to make encryption and decryption with example?

1870

What is informatica? Why do we need it?

1059

Explain what is informatica metadata and where is it stored?

1008

What are the uses of etl tools?

1083

Which transformation is needed while using the Cobol sources as source definitions?

1141

Explain why we use partitioning the session in informatica?

1030

How can repository reports be accessed without sql or other transformations?

1175

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1044

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1860

How can we use mapping variables in informatica?

1021

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

1753

How to extract the informatica rejected data?

1181

Explain in detail scd type 2 through mapping.

1001

How many types of sessions are there in informatica.please explain them?

1130

For More Un-Answered { Informatica } Questions Click Here