Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

If we use only lookup transformation in a mapping ie,
SourceQualifier-->Lookup --> Target. , here datas are taking
very long time to load in target., so what are steps to
improve the performance in that mapping???????

Question Posted / moorthi_cs

Answers were Sorted based on User's Feedback



If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. ,..

Answer / hari

use order by clause in source qualifier.
Remove un necessary ports in that lookup.
try to restrict lookup cache based on the source data.
create order by clause in lookup override using the lookup
condition columns.
If lookup and source are in same database try to join in
source qualifier.
Drop the indiex on the target table before loading the data.
Check index on source table,
Check source table look tables are analysed properly or not.

Is This Answer Correct ?    7 Yes 0 No

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. ,..

Answer / murali udayagiri

One more point we can add to the first answer.
i.e
Check lookup condition columns are having indexes or not.
If indexes are present check when those are rebuild.Index
snaps are old then rebuild them before going to be start
session.If indexes are not present on conditional columns
just create.

Please let me know if any issues.

Thanks,
Murali Udayagiri

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the types of data warehouses?

0 Answers   Informatica,

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

What is synonym?

2 Answers   Patni,

What did you do in source pre load stored procedure

1 Answers  

What is router transformation

4 Answers   CSC,

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

What are the static cache and dynamic cache in informatica?

0 Answers  

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

How the informatica server increases the session performance through partitioning the source?

1 Answers  

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

For more Informatica Interview Questions Click Here
Categories