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

Informatica Interview Questions

Questions Answers Views Company eMail

How informatica recognizes mapping?

CTS,

2 7381

Is snow flake or star schema used? If star schema means why?

CTS, Sonata,

4 9483

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

DELL,

2 8652

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

DELL,

1 8165

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 4182

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

CTS,

3 14324

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

Infosys,

2278

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

Infosys,

3 9793

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

Accenture,

2 18107

what is index?how it can work in informatica

2040

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

DELL,

5 11467

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 9862

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

2 6733

What is log file,and where is it located,why u r using the log file

TCS,

1 8203

what type of transformation is not supported by mapplets?

CTS,

4 15624

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is Session and Batches?

1108

What are the differences between oltp and olap?

972

What is resilience time?

1137

What is mapping debugger?

1012

define galaxy repository in informatica

2228

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

What differs when we choose the sorted input for aggregator transformation?

1022

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

What are the informatica performance improvement tips

1093

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

In informatica workflow manager, how many repositories can be created?

1361

How many dimensions are there in informatica?

1085

Explain sql transformation in script mode examples in informatica

1132

What is sq transformation?

1163

For More Un-Answered { Informatica } Questions Click Here