joins confusion

Six Stars

joins confusion

iCapture4.PNGhow to join following joins in tmap means we should use two tmaps are only one is enough which component is considered as main in above mentioned components..

Moderator

Re: joins confusion

Hello,

What's your input source data? DB tables? More information about your current situation will be preferred.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Six Stars

Re: joins confusion

tables names are 

so-sales_order

sod-sales_order_details

customer (table consists of aliases)cs.customer,c.customer,scu.customer,oc.customer,dc.customer

hence their are five customer tables

bn-beneficiary

B-brand

sc-service_category

pc-phone_card

bg-brand_group

sr-sales_request

cla and clc are aliases of same table (cell_location)

srgcr and dstgr are aliaes of same table(pin_server_config)

 

you just give me the outline how to make joins like, I have to split in to multiple jobs or can I make it in single job 

According above joins I have sent in previous question please give me the out line how will you join those tables if any other components are used other than t map

Thanks in advance 

Regards

A.Sumanth

Fifteen Stars TRF
Fifteen Stars

Re: joins confusion

Hi,
Sorry but your question is not clear.
However, what's the problem with the SQL query from your 1st post?

TRF
Six Stars

Re: joins confusion

I want to develop an output table using those joins in sql query

 

Six Stars

Re: joins confusion

using talend job I want to develop an output table using those joins in above sql query

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download