Hi,
I have to extract multiple tables record and write into the different CSV files.
Extraction is simple (Select * from table),In Server Edition do you have idea of writing code in DS where we will define the table name , Connection strings of DB and get extracted the record in CSV with Table Definition.
EX:
Table File
ABC ABC.CSV
BCA BCA.CSV
CBA CBA.CSV
Thanks
Write code to extract record from multiple tables to Files.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ray.wurlod wrote:No, you don't need 100 extracts. For 95 tables each with different metadata, 95 jobs should do it. ...
I think the question JITeam's was trying to ask is similar to mine; and that is:
Is there a way to parameterize the table definition in a job? Or is it possible to specify the definition as an external (operating system) object or as a DS_METADATA object rather than explicitly listing each column in the job?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And the answer is, and remains, not in server jobs.
Parallel jobs give more flexibility, through the use of schema files, but things are always metadata driven.
Just don't expect any "T" in your "ETL".
Parallel jobs give more flexibility, through the use of schema files, but things are always metadata driven.
Just don't expect any "T" in your "ETL".
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom