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 5596

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

TCS,

5 9755

what is unique constraint error ?

TCS,

2 6614

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

TCS,

1 7882

where to select code page option?

TCS,

2 7250

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

TCS,

4 11171

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

6 20585

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 7054

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 9308

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 13595

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 11830

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 7204

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

2374

normalizer transformation

CTS,

3 7074

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 7535

Post New Informatica Questions

Un-Answered Questions { Informatica }

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2412

Scheduling properties,whats the default (sequential)

2014

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

1055

can you please explain me pre session and post session options?

7680

To import the flat file definition into the designer where should the flat file be placed?

1105

What is mapping debugger?

1070

How we can use union transformation?

1104

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

2374

What is difference between a gateway node and worker node?

1204

What is an expression transformation?

1081

What is a sequence generator transformation?

1075

Suppose we do not group by on any ports of the aggregator what will be the output?

1101

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

What is sorter transformation?

1111

What is the cumulative sum and moving sum?

1238

For More Un-Answered { Informatica } Questions Click Here