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 23184

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

6 14062

Where is the cache stored in informatica?

Infosys, Satyam,

5 38000

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

HCL,

3 21390

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

1 6681

what is polling?

Informatica,

1 7124

what is difference between dimention table and fact table?

1 8474

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

Patni, TCS,

4 31973

How to import oracle sequence into Informatica?

Satyam,

3 16845

What is data merging,data cleansing,sampling?

4 10227

What is IQD file?

1 5531

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

1 9235

what is the exact meaning of domain?

3 23486

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

1 4812

What is the difference between Power Centre and Power Mart?

TCS,

5 21309

Post New Informatica Questions

Un-Answered Questions { Informatica }

explain one complex mapping with logic? sales project?

6612

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

1005

Explain Dataware house architecture .how data flow from intial to end?

2548

Explain in detail about scd type 1 through mapping.

1307

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1113

What is the difference between stop and abort in informatica

1053

What is a predefined event?

1047

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1088

What are the differences between source qualifier and joiner transformation?

1008

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2200

Explain the use of aggregator cache file?

1200

How to load data in informatica ?

965

What are the different components of powercenter?

998

What is option by which we can run all the sessions in a batch simultaneously?

1090

Write the unconnected lookup syntax?

1042

For More Un-Answered { Informatica } Questions Click Here