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 16884

task is running successfully but data is not loded why?

2 7485

what is the difference between Informatica7.1 & informatica 8.1

4 9588

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 7231

can a port in expression transf be given the name DISTINCT

3 13666

how to obtain performance data for individual transformations.

2 10467

what is mapping optimization? wat are the techniques for tat

2 7815

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19476

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 6814

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 9194

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 14963

daily how much amount of data send to production?

HSBC,

4 9790

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

HSBC,

7 22664

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 22537

how to we create datamart?

HSBC,

2 8492

Post New Informatica Questions

Un-Answered Questions { Informatica }

How you prepared reports for OLAP?

1662

Explain the tuning lookup transformation - informatica

1049

What are junk dimensions?

1117

Is there any target staging area in informatica not staging area

2634

explain about unit testing? in real time?

2265

What are the advantages of using informatica as an etl tool over teradata?

1083

Slowly changing dimensions, types and where will you use them

1774

What is a dimensional model?

1035

Explain lookup transformation is active in informatica

1152

Where are the source flat files kept before running the session?

1144

Define sessions in informatica etl?

1106

What is a joiner transformation?

1038

expain about the tune parameters?

2460

What is the use of transformation?

1061

Define update strategy?

1322

For More Un-Answered { Informatica } Questions Click Here