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

Informatica Interview Questions

Questions Answers Views Company eMail

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

HCL, Schneider,

2 12587

if soource is having 10 records how will u insert 20 records to target

HCL,

6 12560

In session log thier should not be a single error how will u do

HCL,

3 9266

What is an incremental loading? in which situations we will use incremental loading

HCL,

2 9415

what is diff between IN and EXIT commands

HCL, Schneider,

1 7251

what is persistant cache in which situation we will use persistantcache

HCL,

1 6946

Insert else update option in which situation we will use

HCL,

4 11526

what is pre and post sql and what is diff between source presql and target pre sql

HCL, IBM,

1 19611

why we use datawarehouse

HCL,

2030

why we need informatica

HCL,

2 13640

what is degenerated dimension table with scenario

HCL,

2 3778

Explain factlessfact table with scenario

HCL,

1 3463

What is confirmed dimension with scenario

HCL,

1 3506

Diffrence between static and dynamic cache

HCL,

2 6563

If u r using dynamic cache lookup port will be thier in thet which option u will select

HCL,

1 3503

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the different types of olap? Give an example?

1099

Under which circumstances, informatica server creates reject files?

1142

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1848

what is informatica metadata?

1094

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2579

Where is metadata stored?

1197

What is session task and command task?

1405

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2132

Why is sorter an active transformation?

1199

What is rank transformation in informatica

1237

Explain direct and indirect flat file loading (source file type) - informatica

1359

What is meant by lookup transformation?

1191

What is the fact table?

1145

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2375

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2176

For More Un-Answered { Informatica } Questions Click Here