Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below are the sample fields and sample table can you please suggest how should i handle comman fields and null values.
salestable:
saleid,
name
desc
region
customertable:
custid
name
desc
region
statetable:
stateid,
name
desc
region
salesresulttable:
salesid
result
facttable:
saleid,
custid,
stateid,
profit
loss
date
Thanks
Hey Deepak ,
try to this
salestable:
saleid,
name as Sales_name
desc as Sales_desc
region as Sales_desc
left join
salesresulttable:
salesid
result
customertable:
custid
name as Cust_name
desc as Cust_desc
region as Cust_region
statetable:
stateid,
name as State_name
desc as State_desc
region as State_region
facttable:
saleid,
custid,
stateid,
profit
loss
date
Then reload your script automatically its create star schema.
Hi Deepak,
Something like below,
QUALIFY '*';
UNQUALIFY '%*',Profit,loss,date,result;
facttable:
saleid as %salesid,
custid as %custidsid,
stateid as %stateid,
profit
loss
date
salestable:
saleid as %salesid,
name
desc
region
customertable:
custid as %custid,
name
desc
region
statetable:
stateid as %stateid,
name
desc
region
salesresulttable:
salesid as %salesid,
result
But I am not sure what is your requirement. So, kindly consider this as an Idea.
Hey Deepak ,
try to this
salestable:
saleid,
name as Sales_name
desc as Sales_desc
region as Sales_desc
left join
salesresulttable:
salesid
result
customertable:
custid
name as Cust_name
desc as Cust_desc
region as Cust_region
statetable:
stateid,
name as State_name
desc as State_desc
region as State_region
facttable:
saleid,
custid,
stateid,
profit
loss
date
Then reload your script automatically its create star schema.
Thanks bhai how are u?