Interested to Buy Any Domain ? << Click Here >> for more details...
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
- 2 Answers
- 6187 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).
Or
Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How can you differentiate between powercenter and power map?
How does a rank transform differ from aggregator transform functions max and min?
where to store informatica rejected data?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Tell me about MD5 functions in informatica
What is meant by active and passive transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Which files are created during the session rums by informatics server?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Enlist the advantages of informatica.
Enlist few areas or real-time situations where informatica is required.
is it possible to index the data in cache of lkp transformation ?
Partition, what happens if the specified key range is shorter and longer
