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

Informatica Interview Questions

Questions Answers Views Company eMail

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 12740

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 42591

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

TCS,

8 9983

I want load the data into target with out 1st and last record.

Yash Technologies,

5 9992

What is polling in informatica ?

TCS,

1 12011

how to delete duplicate records by using filter transfermation?

3 7968

what is unit testing?tell me proceedure

L&T, UST,

2221

Tell me one complex query in oracle ?

L&T, Satyam,

2 7853

How to delete the data in the target table after loaded.

TCS,

3 9304

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10592

what is diff b/t sorter t/r and agg have the option sorter property...

2171

How to delete the (flat file) data in the target table after loaded.

TCS,

2 7651

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2334

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

TCS,

2 7246

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

Patni,

2121

Post New Informatica Questions

Un-Answered Questions { Informatica }

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1640

What are the components of workflow manager?

1096

What is the surrogate key?

1261

Parameter and variable differences

2060

What is mapping debugger?

1012

State the differences between sql override and lookup override?

1207

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

2256

In how many ways we can create ports?

1123

What you know about transaction control transformation?

994

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

What is powercenter on grid?

1177

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7388

What is the use of target designer?

1053

what is song in infrmatica...?

2236

What is meant by pre and post session shell command?

1159

For More Un-Answered { Informatica } Questions Click Here