1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Can anyone give some input on "Additional Concurrent
Pipelines for Lookup Cache Creation" ? I know that this
property is used to build caches in a mapping concurently.
But which values should I set into this ( i.e. 1 or 2 or 3
or something else ) for concurrent cache building ?

Question Posted / abhik


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation"..

Answer / hari

when u set this property value to 3
when u start the session immidiatly i will try to create 3
lookups and try to buils on those lookup's

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Informatica Interview Questions

Whats the difference between $, $$, $$$

9 Answers  

Explain what are the different types of transformation available in informatica.

0 Answers  

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

without using rank transformation how can we rank items by using some other transformations

2 Answers  

What are active transformations.

0 Answers  




there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

What is a node in Informatica?

0 Answers  

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

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

4 Answers   CSC,

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

can u give example for factless fact table

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories