cancel
Showing results for 
Search instead for 
Did you mean: 

BODS queryTransformation

seshagiri_peddi1
Discoverer

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?

Accepted Solutions (1)

Accepted Solutions (1)

rajan_burad
Active Participant

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

seshagiri_peddi1
Discoverer

Thanks Rajan..Its working !!

Answers (0)