Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?
- 6 Answers
- 10818 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhu
You can delete all unused columns from lookup.Then lookup
will create cache only on columns in lookup.This will
improve the performance too.
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How you know when to use a static cache and dynamic cache in lookup transformation?
how we can load rejected record's at run time?(not through bad files)
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a standalone command task?
What is the need of an ETL tool?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain target update override in informatica
What is rank transform?
Tell me about MD5 functions in informatica
What is decode in informatica?
How to load a Dimension ? and how to load a fact table?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a joiner transformation?
What is repository manager?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
