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
- 11098 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
Separate from an archive server and a powerhouse?
What is informatica metadata and where is it stored?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
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?
Can we create two repositories on same database instance in oracle?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
4 yrs etl devloper roles and responsibilities?any body give solutions
Reusable transformation and shortcut differences
What is the difference between Active and Passive transformation?
How will the document be delivered to me?
How does a rank transform differ from aggregator transform functions max and min?
What's the layout of parameter file (what does a parameter file contain?)?
What is rank transformation in informatica
How to create a non-reusable instance of reusable transformations?
To import the flat file definition into the designer where should the flat file be placed?
