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

Informatica Interview Questions

Questions Answers Views Company eMail

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23144

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 14002

Where is the cache stored in informatica?

Infosys, Satyam,

5 37952

If you want to create indexes after the load process which transformation you choose?

HCL,

3 21359

what happens if you try to create a shortcut to a non- shared folder?

1 6658

what is polling?

Informatica,

1 7104

what is difference between dimention table and fact table?

1 8454

what is worklet and what use of worklet and in which situation we can use it?

Patni, TCS,

4 31935

How to import oracle sequence into Informatica?

Satyam,

3 16813

What is data merging,data cleansing,sampling?

4 10202

What is IQD file?

1 5507

How do you handle decimal places while importing a flatfile into informatica?

1 9207

what is the exact meaning of domain?

3 23453

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 4790

What is the difference between Power Centre and Power Mart?

TCS,

5 21269

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many number of sessions can one group in batches?

1093

What is a code page?

1115

How to partition the Session?

1041

How to load last n records of file into target table - informatica

1019

If informatica has its scheduler why using third party scheduler?

1193

write a query to retrieve the latest records from the table sorted by version(scd)

1004

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2063

What will be the approach?

929

define galaxy repository in informatica

2155

can we override a native sql query within informatica? Where do we do it? How do we do it?

1013

What is meant by pre and post session shell command?

1104

Explain the difference between mapping parameter and mapping variable?

979

How to open an older version of an object in the workspace?

1127

What is the benefit of session partitioning?

1042

Explain the different kinds of facts.

934

For More Un-Answered { Informatica } Questions Click Here