Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 8002 Views
- IBM, TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
well
Cached Lookup: In a lookup cache the entire rows will be
put in the buffer and then will be compared with the in
coming rows
where as
uncached lookup: In the uncahed lookup for every row the
lookup will query the lookup table to get the rows
correct me if i was wrong
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sunil
when lookup cahing is unabled, informatica server queries
the lookup table once,caches the lookup values during
session.This can inprove session performance.
when u disable lookup caching,each time row pass to the
transformation,informatica server issues an select
statement to lookup table for lookup values
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
| Is This Answer Correct ? | 3 Yes | 1 No |
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What is Index Caches size?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
Howmany ways yoU can update a relational source defintion and what are they?
update strategy transformation in informatica
What is the difference b/w natural key and surrogate key
Explain Dataware house architecture .how data flow from intial to end?
What is a configuration management?
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?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Teradata 
