put data from oracle table to flat file
Moderators: chulett, rschirm, roy
put data from oracle table to flat file
Hi,
I'm a new user, I need to put all the of a table to a flat file. Please help me in this. let me know which stage to use and which properties to be used. A detailed description is required. It would be great If any one can help me with a training material which describes how to do it.
I'm a new user, I need to put all the of a table to a flat file. Please help me in this. let me know which stage to use and which properties to be used. A detailed description is required. It would be great If any one can help me with a training material which describes how to do it.
Read the documentation that comes along with the tools.
A) Import table definitions.
B) create a Parallel canvas job.
Within the job use the Oracle Connector and a sequential file stage.
Load the Oracle Connector with the table definition you imported.
Create one job per table you with to import.
Create one Output (sequential) file per table you imported.
Re-read the documentation because you'll need to know a lot more than the above to get your jobs written, compiled, and deployed.
Are you the only developper in your shop? Ask for some help from your peers.
A) Import table definitions.
B) create a Parallel canvas job.
Within the job use the Oracle Connector and a sequential file stage.
Load the Oracle Connector with the table definition you imported.
Create one job per table you with to import.
Create one Output (sequential) file per table you imported.
Re-read the documentation because you'll need to know a lot more than the above to get your jobs written, compiled, and deployed.
Are you the only developper in your shop? Ask for some help from your peers.
-
- 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:
If "Generate SQL" property value is "No" then you provide a compliant (one that matches the information on the Columns tab) SELECT statement in the "SELECT Statement" property. If "Generate SQL" property value is "Yes" then you provide the table name in the "Table name" property, which becomes the FROM clause, and the column names on the Columns tab become the SELECT clause.
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: 5
- Joined: Fri Apr 08, 2011 9:32 am
Hi,
You can also give the table name directly by select the read mode as Table. So they would not be any need of giving the select statement or generate query. This would work if you want to read all the columns from that table. But if you need to select few columns then you need to go for select statement.
Thanks.
You can also give the table name directly by select the read mode as Table. So they would not be any need of giving the select statement or generate query. This would work if you want to read all the columns from that table. But if you need to select few columns then you need to go for select statement.
Thanks.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: