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 5370

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

TCS,

5 9445

what is unique constraint error ?

TCS,

2 6375

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

TCS,

1 7731

where to select code page option?

TCS,

2 7050

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

TCS,

4 10821

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

6 20168

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 6841

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 8990

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 13248

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 11639

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 7035

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

2269

normalizer transformation

CTS,

3 6834

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 7337

Post New Informatica Questions

Un-Answered Questions { Informatica }

scenario where i can use only concurrent execution of workflow.

3093

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1238

Mention a few design and development best practices for informatica?

953

How can we delete duplicate rows from flat files?

1179

what are the Methods For Creating Reusable Transformations?

1117

What is the use of an aggregator cache file?

1157

How to go to the older version for a mapping?

1044

Enlist the various types of transformations.

978

As union transformation gives UNION ALL output, how you will get the UNION output?

1056

What is data caches/ index caches?

1041

What is workflow monitor?

1014

What are the designer tools for creating transformations?

1068

What are the types of lookup transformation?

1036

What is rank transformation?

948

What is expression transformation?

1057

For More Un-Answered { Informatica } Questions Click Here