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

Informatica Interview Questions

Questions Answers Views Company eMail

what is galaxy repository?

2 16782

task is running successfully but data is not loded why?

2 7379

what is the difference between Informatica7.1 & informatica 8.1

4 9377

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 7128

can a port in expression transf be given the name DISTINCT

3 13531

how to obtain performance data for individual transformations.

2 10351

what is mapping optimization? wat are the techniques for tat

2 7699

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19298

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

AHM,

2 6690

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

TCS,

2 9069

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

TCS,

5 14797

daily how much amount of data send to production?

HSBC,

4 9569

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

HSBC,

7 22442

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 22287

how to we create datamart?

HSBC,

2 8400

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the advantages of informatica?

1013

What are the types of presistent cache in look up tr.

2055

What will be the approach?

979

What is the benefit of partitioning a session?

1182

What is decode in static cache?

1178

What is Session and Batches?

1108

Partition, what happens if the specified key range is shorter and longer

2499

What is data transformation manager process?

1156

Which are the different editions of informatica powercenter that are available?

1034

Parameter and variable differences

2060

How can we delete duplicate rows from flat files?

1223

What are the components of the workflow manager?

1134

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

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

1167

What is target designer and target load order?

1103

For More Un-Answered { Informatica } Questions Click Here