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

Informatica Interview Questions

Questions Answers Views Company eMail

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 3384

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 3890

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 4399

explain different levels in pushdown optimization with example?

TCS,

2 7382

waht type of interface is used for testing the data in informatica

CTS, TCS,

2302

wat are deployement groups in informatica, how it will be used for developers

1777

what is the difference between informatica6.1 and infomatica7.1

TCS,

2366

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9137

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 9077

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 7907

Is there any model difference between ODS and DWH

Zensar,

2 7465

How You Pull the records on daily basis into your ETL Server.

TCS,

2 7293

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 15191

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 6883

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to configure mapping in informatica?

1226

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2799

What are the differences between oltp and olap?

1018

what is unit testing?tell me proceedure

2279

How to join three sources using joiner? Explain though mapping flow.

1193

Slowly changing dimensions, types and where will you use them

1774

What differs when we choose the sorted input for aggregator transformation?

1076

Write the unconnected lookup syntax?

1133

How many input parameters can exist in an unconnected lookup?

1605

Whats there in global repository

1741

What do you understand by term role-playing dimension?

1122

What could be the possible resons of locks by user?

1146

What is informatica etl tool?

1061

Can informatica load heterogeneous targets from heterogeneous sources?

1239

How to Create a folder using pmrep command?

1225

For More Un-Answered { Informatica } Questions Click Here