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 23345

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

6 14290

Where is the cache stored in informatica?

Infosys, Satyam,

5 38231

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

HCL,

3 21539

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

1 6767

what is polling?

Informatica,

1 7236

what is difference between dimention table and fact table?

1 8556

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

Patni, TCS,

4 32175

How to import oracle sequence into Informatica?

Satyam,

3 17016

What is data merging,data cleansing,sampling?

4 10407

What is IQD file?

1 5620

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

1 9315

what is the exact meaning of domain?

3 23624

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

1 4905

What is the difference between Power Centre and Power Mart?

TCS,

5 21531

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the types of transformations?

1071

How to generate sequence numbers without using the sequence generator transformation?

1212

What is target designer and target load order?

1110

What is aggregator transformation in informatica?

953

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1277

explain abt ur project architecture?

2198

explain about unit testing? in real time?

2209

What do you understand by term role-playing dimension?

1049

Describe the impact of several join conditions and join order in a joiner transformation?

1063

What is the command used to run a batch?

1067

What are the different ways to implement parallel processing in informatica?

1426

have u done any performance tuning? how u ll do?

2299

What are the popular informatica products?

1015

How might one distinguish in the case of mapping is right or not without associating session?

1129

what is the size of your data warehousing?

2096

For More Un-Answered { Informatica } Questions Click Here