1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answers were Sorted based on User's Feedback
Answer / rahul
In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.
Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / sreenu
Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.
Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satyam
We use an unconnected transformation when we need one
return column from each row and it receives values from:
LKP expression from another transformation.
Is This Answer Correct ? | 1 Yes | 0 No |
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What did you do in source pre load stored procedure
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
can u give example for factless fact table
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What are the types of caches in lookup?
What is a predefined event?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
How to elaborate tracing level?
what is confirmed fact?
What the difference is between a database, a data warehouse and a data mart?