Skip to Content

BODS queryTransformation

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 23, 2018 at 11:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.