You are not logged in.

Select with two flatfiles (join)

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

wudycool

Intermediate

  • "wudycool" started this thread

Posts: 10

Date of registration: Mar 18th 2009

  • Send private message

1

Wednesday, June 10th 2009, 12:51pm

Select with two flatfiles (join)

Hi there, maybe i have a mental block but i dont know how i can make a select statement like
flatfile1= a
flatfile2= b
"select a.a,b.a,c.b,d.b,... from a, b where d.a=d.b"
i can not set up a source with two connections and put there my query, right?
but how can i do it with a pipeline? i mean where and how do i set up the query?
thanks a lot!

This post has been edited 1 times, last edit by "wudycool" (Jun 10th 2009, 12:52pm)

sivgin

Sage

Posts: 163

Date of registration: Feb 4th 2009

Location: berlin

  • Send private message

2

Wednesday, June 10th 2009, 6:38pm

Hi

should be TableJoin in chapter 3.3.5 of etl server manual.

Comment: "Two sources are joined via one or several key fields. The sources may belong to different
source systems, so e.g. Joins over Flat Files and different relational database systems are
possible."
sivgin
Rate this thread