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 3006

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

2037

Whats there in global repository

1692

Repository user profiles

1762

How do you set a varible in incremental aggregation

1891

Can you create a flatfile target

ABC,

3 4126

What did you do in source pre load stored procedure

1 2468

Scheduling properties,whats the default (sequential)

1955

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

1 3030

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

1 2879

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

Cap Gemini,

2499

Performance tuning( what you did in performance tuning)

Infosys,

1982

What are conformed dimensions?

1 3024

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

1808

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

1 2923

Post New Informatica Questions

Un-Answered Questions { Informatica }

Define pmcmd command?

1040

What are the differences between a connected lookup and unconnected lookup?

1070

How can we use mapping variables in informatica? Where do we use them?

1200

How to configure mapping in informatica?

1173

What is Cognos script editor?

4229

What are the components of the workflow manager?

1134

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2334

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

How can we use mapping variables in informatica?

1063

How to generate sequence numbers using expression transformation?

1089

What could be the possible resons of locks by user?

1091

What is depict expression change?

1118

What are the different transaction levels available in transaction control transformation?

1202

What do you understand by term role-playing dimension?

1048

Where do we use mapping variables in informatica?

1065

For More Un-Answered { Informatica } Questions Click Here