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 7506

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

CTS, Sonata,

4 9642

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 8795

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

DELL,

1 8253

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 4272

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 14491

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,

2339

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 9931

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 18216

what is index?how it can work in informatica

2087

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

DELL,

5 11677

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 10039

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 6857

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

TCS,

1 8287

what type of transformation is not supported by mapplets?

CTS,

4 15824

Post New Informatica Questions

Un-Answered Questions { Informatica }

Quickly characterize reusable change?

1188

wf dont have integration severances how you can run?

1991

How can we use mapping variables in informatica? Where do we use them?

1297

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10335

what is Active lock explain

2861

What are the tasks that source qualifier perform?

1145

How do you migrate data from one environment to another?

1151

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

2026

Is there any target staging area in informatica not staging area

2634

What you know about transaction control transformation?

1062

Enlist the various types of transformations.

1128

What is expression transformation?

1148

What is DR strategy for Informatica project?

1230

How to differentiate between the active and passive transformations?

1233

How to extract sap data using informatica?

1098

For More Un-Answered { Informatica } Questions Click Here