Interested to Buy Any Domain ? << Click Here >> for more details...
Can i create a lookup table without cache.
- 7 Answers
- 11849 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 is the default join that source qualifier provides?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
how to load dimension table and fact table. plz tell me the steps.
What is incremental aggregation?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Which version configuration tool used in ur project?
what is diffrence b/w joner and union transfermation
To import the flat file definition into the designer where should the flat file be placed?
How to load the data from people soft hrm to people soft erm using informatica?
explain about session partitions ?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Global and Local shortcuts. Advantages.
Teradata 
