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 ?
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 |
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
When will you use SQL override in a lookup transformation?
What are the restrictions of union transformation?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
In which scenario did you used pushdown optimization?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
How we can create indexes after completing the loan process?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is data driven?
difference between stop and abort
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query