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

Informatica Interview Questions

Questions Answers Views Company eMail

How can you access the remote source into your session?

1 6245

What is difference between partioning of relatonal target and partitioning of file targets?

2 13875

what are the transformations that restricts the partitioning of sessions?

1 8935

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43621

What is power center repository?

1 11795

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8725

What are the new features in Informatica 5.0?

1 4808

what is incremantal aggregation?

1 6007

What are the scheduling options to run a sesion?

2 11495

What is difference between stored procedure transformation and external procedure transformation?

2 14436

Explain about Recovering sessions?

1 6100

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 18876

How to recover the standalone session?

2 7145

How can you recover the session in sequential batches?

1 9699

How can you complete unrcoverable sessions?

1 5505

Post New Informatica Questions

Un-Answered Questions { Informatica }

Is there any way to read the ms excel datas directly into informatica?

1020

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8197

what are the Methods For Creating Reusable Transformations?

1166

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9112

what are 3 tech challenges/ common issues you face?

2342

How many input parameters can exist in an unconnected lookup?

1542

How to configure mapping in informatica?

1171

What are the data movement modes in informatica?

1145

Can we create a node as a gateway node and the same node can be assigned to a grid?

1075

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1078

What are the issues you have faced in your project? How did you overcome those issues?

2359

What is joiner transformation in informatica?

1043

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2024

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

2092

Why do you use Mapping Parameter and mapping variable?

1758

For More Un-Answered { Informatica } Questions Click Here