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 12323

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

HCL,

6 12041

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

HCL,

3 8995

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

HCL,

2 9185

what is diff between IN and EXIT commands

HCL, Schneider,

1 7109

what is persistant cache in which situation we will use persistantcache

HCL,

1 6778

Insert else update option in which situation we will use

HCL,

4 11205

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

HCL, IBM,

1 19418

why we use datawarehouse

HCL,

1920

why we need informatica

HCL,

2 13406

what is degenerated dimension table with scenario

HCL,

2 3581

Explain factlessfact table with scenario

HCL,

1 3303

What is confirmed dimension with scenario

HCL,

1 3371

Diffrence between static and dynamic cache

HCL,

2 6349

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

HCL,

1 3355

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is xml source qualifier transformation in informatica?

1186

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

How to load the data from a flat file into the target where the source flat file name changes daily?

1022

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

What is union transformation in informatica?

1106

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1737

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2522

wat are deployement groups in informatica, how it will be used for developers

1685

What are batches?

1030

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1040

What is source qualifier transformation in informatica?

960

how tokens will generate?

2165

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3834

What are the tuning techniques you applied during your last project

1985

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10040

For More Un-Answered { Informatica } Questions Click Here