1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

What are the active and passive transforamtions?

 2 6337

What are the connected or unconnected transforamations?

 2 6032

How many ways you create ports?

 1 5313

What are the reusable transforamtions?

 2 5242

What are the methods for creating reusable transforamtions?

 2 5185

What are the unsupported repository objects for a mapplet?

Informatica,

1 8079

What are the mapping paramaters and mapping variables?

 1 5227

Can yoU use the maping parameters or variables created in one maping into another maping?

 2 6087

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

 1 5000

How can yoU improve session performance in aggregator transformation?

TCS,

8 25124

What are the diffrences between joiner transformation and source qualifier transformation?

 2 16330

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

 2 9766

what are the settiings that u use to cofigure the joiner transformation?

 2 5333

What are the join types in joiner transformation?

Informatica,

1 5432

What are the joiner caches?

Informatica,

3 16344

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain pushdown optimization $pushdownconfig parameter - informatica

687

how we can load rejected record's at run time?(not through bad files)

1896

Define filter transformation?

612

What are the different lookup cache(s)?

606

What are the types of caches in lookup?

556




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

7745

What is a standalone command task?

641

Enterprise data warehouse your projects phase by phase explain?

1439

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4754

How to update a particular record in target with out running whole workflow?

1147

What is the difference between writing a joiner query in ANSI style and THETA style?

1900

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1519

Explain lookup transformation is active in informatica

650

What do you mean incremental aggregation?

612

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1062

For More Un-Answered { Informatica } Questions Click Here