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
- 10615 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sairam
IN CONNECTED LOOKUP TRANSFORMATION OUTPUT PORT YOU PUT IN UNCHECK 40 COLOMNS AND YOU GET RESULT 10 COLOUMNS
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / priyank
Except the 10 columns, if any other column is not being
used for any matching/filter condition, then remove the
columns from the look up table and the columns which are
used in the filter condition but are not taken forward in
the target, uncheck the oputput port and keep them as Input
port.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankur saini er.ankur861@gmail.
hey...i think we can use dynamic lookup too..in dynamic
lookup mark ignore the columns you dont want them tp
participate in lookup process rest for every port specify a
expression for lookup..
GUYs...let me know your comments on this...
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / reddy
i think we can use unconnected look up t/r to acieve this.
| Is This Answer Correct ? | 0 Yes | 9 No |
What is a design?
What is InformaticaPowerCenter?
How do we implement materialized view?when to use materialized view?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
scd methodology?
How are parameters defined in informatica?
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
What is CDC? How to implement CDC?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Teradata 
