i have 2 mapings for this 2 mapings i want use only one
lookupt/r how?
Answers were Sorted based on User's Feedback
Answer / lvpr
If the lookup condition is same for both mappings, then
make lookup t/r as reusable t/r
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / sathish
create lookup using transformation developer then you can reuse same lookup in any times
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / usha
we can reuse the LKP in different mapping...
wat we need to do is..
step1:--create a LKP in transformation designer..
if we cerate a transformation in transformation developer
its reusable...
step2:-- create a transformation ...click--->transformation
tab--->changeto reusable
Is This Answer Correct ? | 0 Yes | 0 No |
What are the join types in joiner transformation?
explain about session partitions ?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
how the server recognises , if the session fails after loading the 100 records in to the target
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Kimball and Inmon methodologies?
what is the difference between lookupoveride and joiner?
What are the active and passive transforamtions?