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
How to implement more than 3 sources as input
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.