Can i create a lookup table without cache.
- 7 Answers
- 9432 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 |
What do you understand by a term domain?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Explain about Informatica server process that how it works relates to mapping variables?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can we get two output ports in un-connect transformation?
What is workflow monitor?
How can you generate reports in informatica?
difference between source based commit? and target based commit? which is better with respect to performance?
Teradata 
