Informatica Interview Questions
Questions Answers Views Company eMail

what is galaxy repository?

2 15521

task is running successfully but data is not loded why?

2 6407

what is the difference between Informatica7.1 & informatica 8.1

4 8004

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 5862

can a port in expression transf be given the name DISTINCT

3 12202

how to obtain performance data for individual transformations.

2 9127

what is mapping optimization? wat are the techniques for tat

2 6779

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 17432

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 5784

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 8146

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 13158

daily how much amount of data send to production?

HSBC,

4 7598

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

HSBC,

7 20034

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 19914

how to we create datamart?

HSBC,

2 6905


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the types of lookup transformation?

605


What is intricate mapping?

564


What is the use of transformation?

555


How can we use batches?

578


Briefly explain the aggregator transformation?

570






What is an active transformation?

623


Implementation methodology

1235


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

2007


What is update strategy transform?

546


where to store informatica rejected data?

647


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1479


Explain what are the different types of transformation available in informatica.

534


What is workflow? What are the components of workflow manager?

682


What is meant by lookup transformation?

593


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

604