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 23338

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

6 14276

Where is the cache stored in informatica?

Infosys, Satyam,

5 38225

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

HCL,

3 21529

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

1 6764

what is polling?

Informatica,

1 7227

what is difference between dimention table and fact table?

1 8549

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

Patni, TCS,

4 32169

How to import oracle sequence into Informatica?

Satyam,

3 17007

What is data merging,data cleansing,sampling?

4 10392

What is IQD file?

1 5614

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

1 9309

what is the exact meaning of domain?

3 23619

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

1 4904

What is the difference between Power Centre and Power Mart?

TCS,

5 21523

Post New Informatica Questions

Un-Answered Questions { Informatica }

Where do we use mapping variables in informatica?

1065

What are the types of presistent cache in look up tr.

2055

What are the tasks that can be performed using sq?

1091

What is the command used to run a batch?

1062

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

What is the Process to creating lookup transformation in informatica

1044

Explain informatica architecture - version 8 / 9

1089

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

What is sq transformation?

1163

can you please explain me pre session and post session options?

7564

Explain target update override in informatica

1126

Which transformation should we use to normalise the COBOL and relational sources?

1208

What are the restrictions of union transformation?

1041

What is sequence generator transformation in informatica?

1078

For More Un-Answered { Informatica } Questions Click Here