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 21524

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

1979

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

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 6376

what is curr val use for in sequence generator?

Emphasis,

2 7554

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 4853

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

Emphasis,

2 6315

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

Emphasis, JBL, Wipro,

2 10253

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 11837

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

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 9096

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 11042

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 9031

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

CTS, TCS,

1 6464

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

CTS, FEEE, TCS,

2363

Post New Informatica Questions

Un-Answered Questions { Informatica }

Which is the t/r that builts only single cache memory?

1190

Where do we use mapping variables in informatica?

1065

What do you mean by enterprise data warehousing?

1063

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

How can we store previous session logs?

1078

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1776

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1052

How can you define user defied event?

1030

How to generate sequence numbers using expression transformation?

1089

What is rank index in rank transformation?

1079

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

2379

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

How does a rank transform differ from aggregator transform functions max and min?

1204

What is pmcmd command?

1117

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003

For More Un-Answered { Informatica } Questions Click Here