put data from oracle table to flat file

bkar · Post by **bkar** » Tue May 24, 2011 11:23 am

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.

PaulVL · Post by **PaulVL** » Tue May 24, 2011 11:28 am

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.

bkar · Post by **bkar** » Tue May 24, 2011 11:41 am

Thanks a lot. I'm alone here to work on datastage and I have used different ETL tool before.

I have imported the table and linked it to a sequential file. When I'm trying to compile it is throwing error "property select statement is required"

ray.wurlod · Post by **ray.wurlod** » Tue May 24, 2011 5:03 pm

You have neither provided, nor asked DataStage to generate, the SELECT statement.

bkar · Post by **bkar** » Wed May 25, 2011 12:15 am

How I need to provide that

ray.wurlod · Post by **ray.wurlod** » Wed May 25, 2011 12:22 am

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.

Poornimayvs · Post by **Poornimayvs** » Wed May 25, 2011 9:21 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.

bkar · Post by **bkar** » Thu May 26, 2011 12:48 am

Thanks a lot for your replies. It got resolved now.

ray.wurlod · Post by **ray.wurlod** » Thu May 26, 2011 12:50 am

PaulVL · Post by **PaulVL** » Thu May 26, 2011 1:18 pm

And FYI: You will want the job called from a Sequencer.

bkar · Post by **bkar** » Fri May 27, 2011 12:33 am

I have specified the select statement in properties