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

Informatica Interview Questions

Questions Answers Views Company eMail

How do you recover rows from a failed session

1 2926

Sequence generator, when you move from develoment to production how will you reset

1961

Whats there in global repository

1648

Repository user profiles

1724

How do you set a varible in incremental aggregation

1830

Can you create a flatfile target

ABC,

3 4013

What did you do in source pre load stored procedure

1 2419

Scheduling properties,whats the default (sequential)

1904

In a concurrent batch if a session fails, can you start again from that session

1 2945

When you move from devel to prod how will you retain a variable

1 2787

Partition, what happens if the specified key range is shorter and longer

Cap Gemini,

2447

Performance tuning( what you did in performance tuning)

Infosys,

1923

What are conformed dimensions?

1 2948

what are factless facts? And in which scenario will you use such kinds of fact tables.

1754

can you avoid static cache in the lookup transformation? I mean can you

1 2855

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is exclusive and normal mode for repository services?

1079

define galaxy repository in informatica

2169

What is informatica worklet?

995

What are the types of caches in lookup? Explain them.

927

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1068

What are the prerequisite tasks to achieve the session partition?

1193

explain about unit testing? in real time?

2148

whats the logic to load the lower level of granularity of data to fact table.

2219

What is the difference between STOP and ABORT options in Workflow Monitor?

1200

What is a predefined event?

1047

what is size of u r database?

2262

Define the various join types of joiner transformation?

953

Why update strategy and union transformations are active? Explain with examples.

1189

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2079

Explain constraint based loading in informatica

1050

For More Un-Answered { Informatica } Questions Click Here