Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
Temp_Data:
Load * Inline [
Code
10
] ;
inner join
Data:
Code, Name,Region,Plant
From..... Where plant >= 100 and plant <=200;