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

Informatica Interview Questions

Questions Answers Views Company eMail

if i have a delimited file as source so how can we seperate this file into three diff targets?

TCS,

2 5483

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

TCS,

5 9600

what is unique constraint error ?

TCS,

2 6491

How do we implement materialized view?when to use materialized view?

TCS,

1 7799

where to select code page option?

TCS,

2 7161

create a mapping to retrieve the employees who are getting salary greater than average salary?

TCS,

4 10986

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 20320

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 6933

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

CSC,

4 9141

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

TCS,

5 13428

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 11729

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

TCS,

1 7110

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

normalizer transformation

CTS,

3 6965

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

DELL,

2 7429

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747

What is the difference between informatica 7.0 and 8.0?

1016

What is informatica etl tool?

1000

While migrating the data from one environment to another environment how would you manage the connections?

1090

How to improve the performance of a session using sorter transformation?

1146

can anyone suggest best free Talend data integration training online

1691

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

Explain the informatica workflow?

1074

Implementation methodology

1714

can we override a native sql query within informatica? How do we do it?

1126

What are the new features of Power Center 5.0?

1779

How to extract sap data using informatica? What is abap? What are idocs?

1182

State the limitations where we cannot use joiner in the mapping pipeline?

1067

What are multi-group transformations?

1103

For More Un-Answered { Informatica } Questions Click Here