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.

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

Can we create a Integration service without a Repository service and vice versa?

0 Answers  

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

What is operational data source (ODS)?

7 Answers  

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers