Informatica Interview Questions
Questions Answers Views Company eMail

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 21723

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

6 12069

Where is the cache stored in informatica?

Infosys, Satyam,

5 35698

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

HCL,

3 19388

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

1 5791

what is polling?

Informatica,

1 6067

what is difference between dimention table and fact table?

1 7681

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

Patni, TCS,

4 30326

How to import oracle sequence into Informatica?

Satyam,

3 15514

What is data merging,data cleansing,sampling?

4 8776

What is IQD file?

1 4837

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

1 8409

what is the exact meaning of domain?

3 22244

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

1 4158

What is the difference between Power Centre and Power Mart?

TCS,

5 19177


Post New Informatica Questions

Un-Answered Questions { Informatica }

How to generate or load values in to the target table based on a column value using informatica etl tool.

590


Explain why we use partitioning the session in informatica?

589


is it possible to index the data in cache of lkp transformation ?

1501


What are Dimensional table?

585


What is sorter transformation?

556






Can you generate sequence numbers without using the sequence generator transformation?

576


What is the meaning of up gradation of repository?

1362


Informatica settings are available in which file?

568


How to configure mapping in informatica?

650


What is workflow monitor?

568


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

1375


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

572


COM components can be used in Informatica

1843


Explain the code page compatibility?

617


what is degenerated dimension?

3126