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

Informatica Interview Questions

Questions Answers Views Company eMail

what r the transformations that r not involved in mapplet?

Wipro,

8 32236

what is data driven?

TCS, Wipro,

5 54155

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 10270

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

TCS,

5 25513

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 11888

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

Target,

9 20798

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

TCS,

2 10373

HOW TO GET THE LATEST DATA IN SCD ?

TCS,

4 21936

what is the function of 'F10' informatica ?

IBM,

4 15857

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

TCS,

3 10806

what are the reusable tasks in informatica ?

CTS, HP, IBM, TCS,

11 55042

HOW DO YOU PARFORM INCREMENTAL LAOD ?

SAIC,

7 17011

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

Oracle,

4 13862

HOW DO YOU CONNECT TO REMOTE SERVER ?

Patni, TCS,

1 8689

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

Target,

7 34880

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the use of aggregator cache file?

1323

How would you copy the content of one repository to another repository?

1064

Did u used latest transformations of 8.6.0? for what?

1933

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

What is the Rank index port in Rank transformation?

1106

How do you use reject loader.

2653

What is the advantage of informatica?

1129

How to implement security measures using repository manager?

1246

Do you find any difficulty while working with flat files as source and target?

1153

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

9310

Could you explain what is enterprise data warehouse?

1230

Enlist the tasks for which source qualifier transformation is used.

1076

What is different between the data warehouse and data mart?

1114

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1805

How to load the data from people soft hrm to people soft erm using informatica?

1070

For More Un-Answered { Informatica } Questions Click Here