Interested to Buy Any Domain ? << Click Here >> for more details...
Can i create a lookup table without cache.
- 7 Answers
- 11693 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 |
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What are the performance considerations when working with aggregator transformation?
In target table how to display the system time
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
Explain in detail scd type 2 through mapping.
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is a pre-defined event and user-defined event?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
What is the Difference between SetVariable and setmaxvariable in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How do you set a varible in incremental aggregation
Teradata 
