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 23186

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

6 14067

Where is the cache stored in informatica?

Infosys, Satyam,

5 38009

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

HCL,

3 21393

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

1 6682

what is polling?

Informatica,

1 7125

what is difference between dimention table and fact table?

1 8476

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

Patni, TCS,

4 31979

How to import oracle sequence into Informatica?

Satyam,

3 16850

What is data merging,data cleansing,sampling?

4 10229

What is IQD file?

1 5533

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

1 9237

what is the exact meaning of domain?

3 23491

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

1 4815

What is the difference between Power Centre and Power Mart?

TCS,

5 21312

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to generate sequence numbers?

1040

What is a sequence generator transformation?

966

What if the source is a flat-file?

1056

What do think which one is the better joiner or look up?

1162

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1863

How many transformations can be used in mapplets.

1887

Clarify the aggregator change?

979

What do you mean by filter transformation?

911

What is meant by lookup transformation? Explain the types of lookup transformation?

908

What is sq transformation?

1092

What is a joiner transformation?

944

What is the difference between source qualifier transformations source filter to filter transformation?

1007

How can we use mapping variables in informatica?

1014

How to create or import flat file definition in to the warehouse designer?

1036

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

1977

For More Un-Answered { Informatica } Questions Click Here