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 11276

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

2 8542

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 16582

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 14816

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 36669

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9423

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

Informatica,

1 7072

how to work with mapplet designer in informatica?

7 24589

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 25892

How to generate the HTML output using Informatica.

Wipro,

3 12129

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

2 10255

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

TCS,

2 25479

.prm wirh repalce .txt is possible?

2 8065

how tokens will generate?

2204

what transformations are used for Variable port?

2 21077

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is exclusive and normal mode for repository services?

1144

Explain the aggregator transformation?

1165

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

What is the meaning of up gradation of repository?

1988

can u give example for factless fact table

6648

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

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

1147

What are the types of caches in lookup? Explain them.

970

update strategy transformation in informatica

1064

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1049

What are different types of transformations available in informatica?

992

What is a filter transformation and why it is an active one?

968

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

What are the tasks that can be performed using sq?

1091

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906

For More Un-Answered { Informatica } Questions Click Here