Data Model Doubts.....

[subbareddykm]

Hi All i have some doubts in data model while creating Optimizing and using joins and keeps.

For Example :

Temp_Data:

Load * Inline [

Code

10

] ;

Data:

Code, Name,Region,Plant

From..... Where Exists(Code);

Doubts:

1.Here i m fetching data code=10 using Where Exists  but how to apply left keep to this table.

2. I want to load Plant 100 to 250.How to load only 100 to 250 plants.

[maxgro]

1) I don't understand; left keep from which tables? and what's the result you want to achieve?

2)

Where Exists(Code)

and Plant > 100 and Plant < 250;

[PradeepReddy]

1) No need of Left Keep.

    you are fetching the records from the source table, where the Code is available in Temp_Data. It carters your requirement.

2) Load *  from Source where Exists(Code) and Plant > 100 and Plant < 250;

[rajeshforqlikvi]

Temp_Data:

Load * Inline [

Code

10

] ;

inner join 

Data:

Code, Name,Region,Plant

From..... Where plant >= 100 and plant <=200;