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

Informatica Interview Questions

Questions Answers Views Company eMail

Plz..let me know differences between Informatica 7.1 and 8.1?

3 11274

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 8538

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

Tech Mahindra,

7 16572

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

TCS,

6 14807

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

Deloitte,

10 36630

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9420

wht is full process of Information source to target just like stg to productuon and development

Informatica,

1 7069

how to work with mapplet designer in informatica?

7 24575

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

Deloitte,

7 25864

How to generate the HTML output using Informatica.

Wipro,

3 12122

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 10245

wt is Dynamic lookup Transformation? when we use?how we use?

TCS,

2 25464

.prm wirh repalce .txt is possible?

2 8056

how tokens will generate?

2196

what transformations are used for Variable port?

2 21061

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is event and what are the tasks related to it?

1118

Define update strategy?

1214

How do you load alternate records into different tables through mapping flow?

1850

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2117

How to load data in informatica ?

1001

Which are the different editions of informatica powercenter that are available?

1032

What are the modules in Power Center

1674

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8197

how we can load rejected record's at run time?(not through bad files)

2374

What is meant by query override?

1055

What are connected or unconnected transformations?

1117

What are the data movement modes in informatica?

1145

How do you load first and last records into target table?

1152

What is meant by pre and post session shell command?

1151

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

For More Un-Answered { Informatica } Questions Click Here