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.

How do you load first and last records into target table?

0 Answers  

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

What are the components of the workflow manager?

0 Answers  

Tell me about informatica architecture.

2 Answers   TCS,

Can we run session without using workflows?

5 Answers   TCS,

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers