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 23320

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

6 14250

Where is the cache stored in informatica?

Infosys, Satyam,

5 38203

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

HCL,

3 21513

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

1 6759

what is polling?

Informatica,

1 7219

what is difference between dimention table and fact table?

1 8543

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

Patni, TCS,

4 32144

How to import oracle sequence into Informatica?

Satyam,

3 16994

What is data merging,data cleansing,sampling?

4 10383

What is IQD file?

1 5609

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

1 9304

what is the exact meaning of domain?

3 23610

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

1 4896

What is the difference between Power Centre and Power Mart?

TCS,

5 21509

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is union transformation?

961

how to load dimension table and fact table. plz tell me the steps.

2092

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2069

What is a grid in Informatica?

1064

What will be the approach?

976

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1105

What are the types of caches in lookup?

1047

Please let me know how to make Data masking in informatica..

1709

How do you change a non-reusable transformation to reusable transformation?

994

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4157

Which development components of informatica have the highest usage?

1033

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1131

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8112

Repository user profiles

1757

What is the difference between stop and abort in informatica

1089

For More Un-Answered { Informatica } Questions Click Here