how to load the data in FTp stage

sureshchandra · Post by **sureshchandra** » Tue Apr 15, 2008 5:04 am

Hi all,
I'm new to use FTP stage.Pls tell me what are the required steps i have to do in FTP stage.To load the meta data for which option i have to choose. Eg for sequential file we go for sequential file defination like that for ftp which option we have to go.

Tnx

chulett · Post by **chulett** » Tue Apr 15, 2008 6:24 am

Not quite sure what you are asking.

Either load the metadata for your source data if you are 'get'ing or your target data for a 'put'. And that just like in any other stage.

sureshchandra · Post by **sureshchandra** » Tue Apr 15, 2008 6:32 am

Hi chulett,
Thanks for ur response.I'm having data in sequential file.
design of th job is Seqfile--------->Trans--------->FTP.
to extract the data from seq to FTP what should i do.

chulett · Post by **chulett** » Tue Apr 15, 2008 6:43 am

Just read it like normal. Propogate the columns to the FTP stage. Supply the remote server's connection parameters.

What problem are you having? What is not working?

sureshchandra · Post by **sureshchandra** » Tue Apr 15, 2008 7:03 am

hi,
i'm not having idea about the FTP stage.
How to propagate the columns in ftp stage.to load the data in ftp what option i have to choose.Eg:To import the meta data for ODBC we go for ODBC table definition.For seq file we go for Sequential file definition.
For FTP which option?pls tell

thanks in advance

chulett · Post by **chulett** » Tue Apr 15, 2008 7:09 am

It depends on your source - in your case 'go for' sequential file definition.

sureshchandra · Post by **sureshchandra** » Tue Apr 15, 2008 7:13 am

Tnx chulett

ray.wurlod · Post by **ray.wurlod** » Tue Apr 15, 2008 3:12 pm

Any table definition in the Repository can be loaded into any stage type.

Table definitions are global in scope, and stored in the same structure irrespective of whence they were imported. This is one of the hidden strengths of DataStage. For example, having imported a table definition of a database table, you can load that definition into a Sequential File stage or Data Set stage that's going to stage the data between the "T" part and the "L" part of your ETL.