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 12443

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

HCL,

6 12272

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

HCL,

3 9122

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

HCL,

2 9292

what is diff between IN and EXIT commands

HCL, Schneider,

1 7175

what is persistant cache in which situation we will use persistantcache

HCL,

1 6856

Insert else update option in which situation we will use

HCL,

4 11350

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

HCL, IBM,

1 19513

why we use datawarehouse

HCL,

1976

why we need informatica

HCL,

2 13501

what is degenerated dimension table with scenario

HCL,

2 3675

Explain factlessfact table with scenario

HCL,

1 3372

What is confirmed dimension with scenario

HCL,

1 3427

Diffrence between static and dynamic cache

HCL,

2 6452

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

HCL,

1 3433

Post New Informatica Questions

Un-Answered Questions { Informatica }

When do you use sql override in a lookup transformation?

1099

Enlist some properties of sessions.

1068

What do you mean by channel change?

1047

Plz can any one say me how to get the informatica certification materials and dumps

2048

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

1064

What are the components of the workflow manager?

1134

Explain lookup transformation is active in informatica

1104

what is SDLC way of code development?

2042

How can we delete duplicate rows from flat files?

1223

Differentiate between router and filter transformation?

1012

What are the types of presistent cache in look up tr.

2055

expain about the tune parameters?

2414

tell me the rules and responsblites in our project(my project is development)

1933

What is aggregate cache in aggregator transformation?

1145

What is meant by LDAP users?

1209

For More Un-Answered { Informatica } Questions Click Here