Informatica Interview Questions
Questions Answers Views Company eMail

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 21759

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

6 12154

Where is the cache stored in informatica?

Infosys, Satyam,

5 35746

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

HCL,

3 19437

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

1 5815

what is polling?

Informatica,

1 6085

what is difference between dimention table and fact table?

1 7714

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

Patni, TCS,

4 30383

How to import oracle sequence into Informatica?

Satyam,

3 15548

What is data merging,data cleansing,sampling?

4 8811

What is IQD file?

1 4855

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

1 8444

what is the exact meaning of domain?

3 22286

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

1 4173

What is the difference between Power Centre and Power Mart?

TCS,

5 19211


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between informatics 7x and 8x and what is latest version?

530


What are the performance considerations when working with aggregator transformation?

662


What do you understand by a term domain?

657


How we can use union transformation?

598


How to extract the informatica rejected data?

737






Define joiner transformation?

580


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8502


What are mapplets? How is it different from a Reusable Transformation?

613


How do you migrate data from one environment to another?

632


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1602


waht type of interface is used for testing the data in informatica

1821


Enlist few areas or real-time situations where informatica is required.

578


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1575


How can repository reports be accessed without sql or other transformations?

709


What is a standalone command task?

641