Can i create a lookup table without cache.
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 |
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Diffrence between 7.1,8.1 and 8.6
how to move the mappings from your local machine to claint place?
Whatis the difference between View and Materialized View ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
can anyone explain me about sales project in informatica?
what type of transformation is not supported by mapplets?
What are active transformations? Name them.