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 is native users?

0 Answers  

what is the difference between mapplet & stored procedure?

1 Answers  

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

What is the Difference between DSS & OLTP?

5 Answers  

what is casual dimension?

6 Answers   IBM,

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

Different sorts of metadata that stores in the storage facility?

0 Answers  

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

For more Informatica Interview Questions Click Here
Categories