Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 8744

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

HCL,

5 7619

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

HCL,

2 5271

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

HCL,

2 6632

what is diff between IN and EXIT commands

HCL, Schneider,

1 5078

what is persistant cache in which situation we will use persistantcache

HCL,

1 4536

Insert else update option in which situation we will use

HCL,

4 8010

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

HCL, IBM,

1 16899

why we use datawarehouse

HCL,

1152

why we need informatica

HCL,

2 11435

what is degenerated dimension table with scenario

HCL,

2 1630

Explain factlessfact table with scenario

HCL,

1 1692

What is confirmed dimension with scenario

HCL,

1214

Diffrence between static and dynamic cache

HCL,

2 4258

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

HCL,

1 1738


Post New Informatica Questions






Un-Answered Questions { Informatica }

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

886


How will the document be delivered to me?

225


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?

6866


wf dont have integration severances how you can run?

1145


How can you generate reports in informatica?

218






What is the cumulative sum and moving sum?

296


Where can we find the throughput option in informatica?

246


What is a passive transformation?

250


Can we create a Integration service without a Repository service and vice versa?

256


Explain dynamic target flat file name generation in informatica

275


How would you join a node to the already existing domain?

240


How to delete duplicate row using informatica?

219


Scheduling properties,whats the default (sequential)

1008


Explain informatica architecture - version 8 / 9

327


Separate from an archive server and a powerhouse?

199