Can i create a lookup table without cache.
- 7 Answers
- 9341 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
I think yes
for an unchached lookup table for every input roe the
lookup will query the lookup table to get the required rows.
HOpe this helps correct me if i was wrong
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / saif
uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / akash
By default caching is not done by informatica, if we want
to use a cache in look up we must set the same in
properties..
Please correct me if I am wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sbvp
my ans is wrong sorry
ans: yes why because they are two types of look up t/r are
there unconn/conn acutally .in that cache/uncahe look t/r's ok
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / sbvp
No,informatica server creates default index cache and data
cache. to evry transformations
| Is This Answer Correct ? | 0 Yes | 14 No |
wht is full process of Information source to target just like stg to productuon and development
Explain Dataware house architecture .how data flow from intial to end?
what is parallel querying and what r hints.
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
what is flat file override?
What are the new features of informatica 9.x in developer level?
how lookup is acting as both active and passive ? how is it possitble?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
Implementation methodology
Can we create a node as a gateway node and the same node can be assigned to a grid?
what is surrogate id ?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Teradata 
