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 22366

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

6 13090

Where is the cache stored in informatica?

Infosys, Satyam,

5 36978

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

HCL,

3 20598

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

1 6229

what is polling?

Informatica,

1 6608

what is difference between dimention table and fact table?

1 8091

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

Patni, TCS,

4 31170

How to import oracle sequence into Informatica?

Satyam,

3 16100

What is data merging,data cleansing,sampling?

4 9463

What is IQD file?

1 5200

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

1 8825

what is the exact meaning of domain?

3 22830

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

1 4501

What is the difference between Power Centre and Power Mart?

TCS,

5 20192

Post New Informatica Questions

Un-Answered Questions { Informatica }

Name at least 5 different types of transformations used in mapping design and state the use of each.?

877

What are the types of schemas we have in data warehouse.

710

Where do we use mapping variables in informatica?

783

what is Active lock explain

2534

What is a repository manager?

836

Briefly define reusable transformation?

819

What is an aggregator transformation?

797

What is aggregate cache in aggregator transformation?

814

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1850

How can informatica be used for an organization?

848

How does a rank transform differ from aggregator transform functions max and min?

883

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

810

In which transformation you cannot drag ports into it?

1024

How can we use batches?

773

How can you define user defied event?

806

For More Un-Answered { Informatica } Questions Click Here