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 11149

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

2 8411

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 16363

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 14564

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 36263

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9309

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

Informatica,

1 6983

how to work with mapplet designer in informatica?

7 24315

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 25648

How to generate the HTML output using Informatica.

Wipro,

3 11977

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

2 10152

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

TCS,

2 25339

.prm wirh repalce .txt is possible?

2 7914

how tokens will generate?

2163

what transformations are used for Variable port?

2 20940

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain scd type 3 through mapping.

926

What is joiner transformation in informatica?

1000

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2809

Under which circumstances, informatica server creates reject files?

1033

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

2201

What you know about transaction control transformation?

945

What is parallel processing in informatica?

1630

How can we use batches?

975

What is source qualifier transformation in informatica?

953

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?

1858

What is a passive transformation?

1047

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7126

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2007

Enlist the advantages of informatica.

1014

What is data transformation manager process?

1090

For More Un-Answered { Informatica } Questions Click Here