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 11124

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

2 8387

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 16324

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 14528

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 36210

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9279

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

Informatica,

1 6964

how to work with mapplet designer in informatica?

7 24280

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 25601

How to generate the HTML output using Informatica.

Wipro,

3 11958

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

2 10132

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

TCS,

2 25315

.prm wirh repalce .txt is possible?

2 7890

how tokens will generate?

2152

what transformations are used for Variable port?

2 20923

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the modules in Power Center

1621

What are the different ways to implement parallel processing in informatica?

1339

how tokens will generate?

2152

How to generate sequence numbers using expression transformation?

1025

How you prepared reports for OLAP?

1545

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1974

How to load last n records of file into target table - informatica

1018

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

2052

Design a mapping to load a target table with the following values from the above source?

1284

What is dynamic cache?

966

What is data movement mode in Informatica and difference between them?

1056

Why union transformation is an active transformation?

992

Differentiate between reusable transformation and mapplet.

1027

What is the use of an aggregator cache file?

1139

What is the commit type if you have a transaction control transformation in the mapping?

968

For More Un-Answered { Informatica } Questions Click Here