Difference between m_mkfs and m_touch
What is the difference between m_mkfs and m_touch. both create a mfs how do they differ ? also what is the syntax for creating mfs using m_touch
Hi, i have 3 files each having 2 cols e.G file1 empid deptid 1 100 2 200 3 200 4 100 5 300 file2 empid salary 1 10 2 20 3 30 4 40 5 ...
1.Perform inner join for both file1 & file2
2.perform sort on dept id then do Roll up
3.perform inner join for roll up o/p and file3
4.finally you will get required result
Hi, i have 3 files each having 2 cols e.G file1 empid deptid 1 100 2 200 3 200 4 100 5 300 file2 empid salary 1 10 2 20 3 30 4 40 5 ...
I believe what you are looking for is a query like this:
select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname
3 way join with different column names.
Hi, i have 3 files each having 2 cols e.G file1 empid deptid 1 100 2 200 3 200 4 100 5 300 file2 empid salary 1 10 2 20 3 30 4 40 5 ...
Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...
Code
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
m_mkfs: to create a multifie system
m_touch: to create a empty file system
M_mkfs will creates a multifile system
M_touch will creates empty multifile