Interested to Buy Any Domain ? << Click Here >> for more details...
wt is Dynamic lookup Transformation?
when we use?how we use?
- 2 Answers
- 25317 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashis
When we use dynamic lookup the process is as follows:
1. When the first record is read from the lookup
table/flatfile, server keeps the value in the RAM also the
same information is written into two auto generated files
(having random names, forgot the type, hope it is something
related to index and cache).
2. When the next record comes for lookup, first the record
is searched in the RAM or created file based on the
conditions used in lookup condition.
3. If not found then searched in the Lookup table.
4. In case of dynamic lookup once value is fetched from the
source with modified fields it will be updated in the RAM
or autogenerated file for further lookup for same key
values, before the completion of the session.
(Example:- in case if emp_id 101 got modified more than one
time between the two runs).
5. In case of static lookup. It will always look into the
already existing value in the lookup table.
| Is This Answer Correct ? | 24 Yes | 6 No |
Answer / padmavathi
What Ashis told is Exactly correct apart of this Actually
when lookup table contains less data then we will go for
the Dynamic Lookup cache, performance increases.If large
data is there means its better to go for static cache.
| Is This Answer Correct ? | 20 Yes | 6 No |
Why update strategy and union transformations are active?
Which is better performance wise database or file?How?
What do you mean by filter transformation?
who to split dimentions into sub dimention
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
star and snowflake schema?
What are limitations of joiner transformation?
Explain pushdown optimization and types in informatica
How do you migrate data from one environment to another?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Teradata 
