How to implement more than 3 sources as input

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chitravallivenkat
Participant
Posts: 106
Joined: Thu Jun 08, 2006 8:51 am

How to implement more than 3 sources as input

Post by chitravallivenkat »

C my requirement is that i have to extract data from different two databases requried fileds and also one more source is file as input.

and i have to check for example
File : File1 Branch & Account code
Database table1 branch_cd & account_cd
so i have to check file and tables columns are equal then goes to final output. so how should i implement this ...?

Please advice which all the stages required for this
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the "branch" in the file the same as the "branch code" in the database table? How many lines in the file? How many rows in the table? These volumes will affect the "best" solution.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
satya99
Participant
Posts: 104
Joined: Thu Nov 30, 2006 1:22 pm

Post by satya99 »

Venkat,

Frame the question in proper format.

How can some one guess what's your database?

So please provide us proper information.

Your question says two database tables, but your example has only one database.

Thanks
satya
Post Reply