Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 1743

What is meant by LDAP users?

1115

What is a shortcut and copy in Informatica and how two are different with each other?

1135

What is exclusive and normal mode for repository services?

1068

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

1083

What is a grid in Informatica?

1003

Can we create a Integration service without a Repository service and vice versa?

1177

What is deployment group?

1137

What are roles and groups and benefits of using them?

996

How to Create a folder using pmrep command?

1108

What happens when a session fails and you click on recover?

1066

Define Pmrep command?

1000

Is it possible to use a client with different version than that of its Informatica server?

1080

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1006

What is the difference between STOP and ABORT options in Workflow Monitor?

1185

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of informatica 9.x in developer level?

941

What is a transaction control transformation?

1148

What is domain and gateway node?

1125

Which is the t/r that builts only single cache memory?

1131

Does an informatica transformation support only aggregate expressions?

977

How can you validate all mappings in the repository simultaneously?

1295

What are the different transaction levels available in transaction control transformation?

1125

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1812

What is a snowflake schema?

930

generate date / time dimension in informatica

1074

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

2042

Define pmcmd command?

995

update strategy transformation in informatica

1020

How to load a Dimension ? and how to load a fact table?

1374

Explain the mapping variable usage example in informatica

1091

For More Un-Answered { Informatica } Questions Click Here