Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have two tables one is Time_dim and other is manufacturing....
Time_dim has fields:
time_id,
time_date,
month,
year
Manufacturing table has fields:
Time_id,
abc,
xyz,
i want to apply the filter on time_id to load only previous day data from manufacturing table and schedule it for every day....
my problem is..how to store the time_id from time_dim table to a variable so that i can aply filter condition to measurement table
Thanks
Hi,
You can try in this way.
Data:
Load
time_id,
time_date,
month,
year
From Time_Dim
join(Data)
Load
Time_id,
abc,
xyz
From Manufacturing;
Data1:
Load
time_id,
time_date,
month,
year
abc,
xyz
Resident Data where time_date = Pre. date
Drop table Data;
Here Pre. Date is a calculation for pre.date.
Regards,
Kaushik Solanki
Hi Kaushik..
Problem with joining table with manufacturing is... it is having billions of records
Is there any other way..?
Hi,
If you've applied the filter in the time_dim table, you can use the Exists() function to apply in manufacturing table.
time_dim:
time_id,
time_date,
month,
year
manufacturing:
time_id,
abc,
xyz
where exists(time_id);
In manufacturing, it will only load rows which time_id has been previously loaded in the time_dim table.
Hope it helps.