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 16646

task is running successfully but data is not loded why?

2 7289

what is the difference between Informatica7.1 & informatica 8.1

4 9196

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 6996

can a port in expression transf be given the name DISTINCT

3 13383

how to obtain performance data for individual transformations.

2 10225

what is mapping optimization? wat are the techniques for tat

2 7580

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19114

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 6597

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 8957

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 14589

daily how much amount of data send to production?

HSBC,

4 9340

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

HSBC,

7 22175

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 21992

how to we create datamart?

HSBC,

2 8259

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the advantages of informatica?

963

How do you handle two sessions in Informatica

1082

Describe data concatenation?

1017

How to elaborate powercenter integration service?

1081

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10638

Differentiate between reusable transformation and mapplet.

1040

complex mapping ur project u r invlve can u explain and give real time example give me ?

2244

What is a shortcut and copy in Informatica and how two are different with each other?

1142

What are the informatica performance improvement tips

1032

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1035

How is union transformation utilized?

959

What are the different lookup cache(s)?

1041

When do you use sql override in a lookup transformation?

1033

What is aggregator transformation in informatica?

904

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1017

For More Un-Answered { Informatica } Questions Click Here