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 12596

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

Cap Gemini,

5 42328

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

TCS,

8 9675

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

Yash Technologies,

5 9780

What is polling in informatica ?

TCS,

1 11876

how to delete duplicate records by using filter transfermation?

3 7799

what is unit testing?tell me proceedure

L&T, UST,

2168

Tell me one complex query in oracle ?

L&T, Satyam,

2 7719

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

TCS,

3 9082

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10370

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

2133

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

TCS,

2 7528

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

2270

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

TCS,

2 7087

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,

2081

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are ETL Tools?

1043

How do you load only null records into target? Explain through mapping flow.

1959

What are the features of complex mapping?

1100

How many dimensions are there in informatica?

1025

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1560

What could be the possible resons of locks by user?

1036

Scheduling properties,whats the default (sequential)

1897

According to his methodology what all you need before you build a datawarehouse

1692

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2023

In informatics server which files are created during the session rums?

1067

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1632

What is depict expression change?

1034

How many ways a relational source definition can be updated and what are they?

956

What is the sql query overwrite in source qualifier in informatica

1030

Which files are created during the session rums by informatics server?

1124

For More Un-Answered { Informatica } Questions Click Here