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
- 10944 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 the difference between a router and a filter transformation?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
What does command task mean?
Diffrence between 7.1,8.1 and 8.6
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
State the limitations where we cannot use joiner in the mapping pipeline?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
How will u find weather dimension table is big in size of a fact table?
Can we run session without using workflows?
What is target update override
What are mapplets?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Teradata 
