on 10-23-2018 11:38 AM
Hi
I have 2 tables like below in flat file
Employee table:
Empid DeptID Empname
101 HR RAMU
102 FI Laxman
Dept table:
DeptID DeptName
HR Human resource
FI Finance
When i trying to merge Dept name at transformation level at BODS ,i am getting below output
Empid Emp name Dept Dept name
101 Ramu HR Human resource
102 laxman FI Human resource
101 Ramu HR Finance
102 laxman FI Finance
But i am expecting output like below
Empid Emp name Dept Dept name
101 Ramu HR Human resource
102 laxman FI Finance
How can i achieve this?
Hi Seshagiri,
You're getting wrong output cause you've not specified any joining condition. It's the output of cross join.
To get the desired output, go to your query transform -> FROM -> Specify joining condition -> Employee.DeptID = Dept.DeptID. (Make it as inner join)
Now execute the job, you'll get the desired output.
Let us know if it helps!
Thanks,
Rajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Rajan..Its working !!
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.