Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
i Stuck a requirement. Please help me for sort out this problem.
Requirement is
Suppose in my fact table
code Sale
Z121 100
Z222 200
AND a code master contain a hierachy.like deatils
means code wise mapping details
z121 A
Z121 B
Z121 C
Z222 D
Z222 E
When i left join Code master to fact.THEN RESULT BELOW
CODE DEATILS Sale
Z121 A 100
Z121 B 100
Z121 C 100
Z222 D 200
Z222 E 200
Requirement is when i left join code master to fact then deatils wise sale which is showing above it should be zero(0)
and z121 wise sale showing 100
z222 wise 200
output format i show you
CODE | DETAILS | Sale |
Z121 | 100 | |
Z121 | A | 0 |
B | 0 | |
C | 0 | |
Z222 | 200 | |
Z222 | D | 0 |
E | 0 |
KINDLY HELP ME FOR SOLVING THIS ISSUE.
OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE
OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE
OUTPUT IS SCREEN SHOT IS ATTACHED.KINDLY SEE