Left join(Small Help)

[ajaykumar1]

Hi All,,

How to reduce the size of the application.

I have two data sources.Before left join source1 have 9 lacks records and 27MB size.After left join total records(settings-documentsProperties--tables) is around 47 Lacks and size is 135 MB.

Note : one ID have multiple DM,PM,PG

Data linkage as below.

Table:

Load ID,

          etc..

          from source1;                     //Total records 9Lacks

left join

Load ID,

          DM,

       PM,

          PG

from source2;                             //540 from excel

Desired o/p : List of ID's from source1 and their respective DM,PM,PG from source2.

Thanks,

Ajay           

[ashfaq_haseeb]

Hi,

Make sure you have same field name in both table for the one you are joining.

Can you post your script here.

Regards

ASHFAQ

[ajaykumar1]

Any hint from anyone?

Thanks,

Ajay

[ajaykumar1]

Thanks Ashfaq.The joining name is same.What am expecting is one ID with multiple PM,DM,PG so it may considering the record count based on multiple Pm,dm,pg values.

Correct me if am wrong.

Ajay

[ashfaq_haseeb]

Ok.

This is known thing, this is how it works.

What is your desired o/p.

Can you attach few lines of sample data.

Regards

ASHFAQ

[ajaykumar1]

Based on the data and desired o/p we can't change the size of the application ..correct?

The output also coming properly when am doing some random validation.My intension is to reduce the size of the application as because of currently am working in personal with some lease license.

Its creating problems to open in local computer.

Thanks,

Ajay

[ashfaq_haseeb]

With this model you can't.

You have to look at business requirement first.

If that's the only solution consider increasing ram on your machine.

Regards

ASHFAQ