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 7698

How to handle changing source file counts in a mapping?

Deloitte, TCS,

3 19297

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 14796

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 22440

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 22285

how to we create datamart?

HSBC,

2 8400

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the differences between oltp and olap?

972

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4727

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

What is pmcmd command?

1116

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008

Have you worked with/created Parameter file

1664

What are the reusable transformations?

1162

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9819

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

How to elaborate powercenter integration service?

1131

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

What is domain and gateway node?

1165

Explian the Process of deployment groups in informatica

1062

How to create or import flat file definition in to the warehouse designer?

1068

For More Un-Answered { Informatica } Questions Click Here