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 23343

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

6 14284

Where is the cache stored in informatica?

Infosys, Satyam,

5 38227

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

HCL,

3 21533

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

1 6765

what is polling?

Informatica,

1 7230

what is difference between dimention table and fact table?

1 8552

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

Patni, TCS,

4 32172

How to import oracle sequence into Informatica?

Satyam,

3 17009

What is data merging,data cleansing,sampling?

4 10399

What is IQD file?

1 5615

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

1 9312

what is the exact meaning of domain?

3 23620

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 21525

Post New Informatica Questions

Un-Answered Questions { Informatica }

Separate from an archive server and a powerhouse?

964

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2123

Does an informatica transformation support only aggregate expressions?

1042

COM components can be used in Informatica

2392

Have you worked with/created Parameter file

1664

What is the use of code page?

1096

Write the unconnected lookup syntax?

1084

Describe data concatenation?

1083

Why sorter is an active transformation?

1193

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2037

Explain what transformation and how many are there in informatica?

958

How many input parameters can exist in an unconnected lookup?

1546

Define mapping and session?

1038

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?

10170

How do you load alternate records into different tables through mapping flow?

1872

For More Un-Answered { Informatica } Questions Click Here