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

Answer / sairam

IN CONNECTED LOOKUP TRANSFORMATION OUTPUT PORT YOU PUT IN UNCHECK 40 COLOMNS AND YOU GET RESULT 10 COLOUMNS

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.

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

Answer / srinivasarao

we can use look up over ride

Answer / reddy

i think we can use unconnected look up t/r to acieve this.

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

What are the reusable transforamtions?

2 Answers  

in performance wise union is past,union all is past

2 Answers  

What is a configuration management?

1 Answers  

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

How does the aggregator transformation handle null values?

0 Answers  

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

what is SDLC way of code development?

0 Answers