DSXchange

is there any way to reach the name of the file when you work on it in datastage

When you say reach, do you mean get the name of the file from which you are reading?
Parameterizing the file name can help you.

There is also the File Name option in the Sequential file stage which lets you have an additional column in the metadata with the file name as the value inside.

If its about deciding filename on runtime, then YES, its possible on many ways.

Hi Kumar

I have no idea how to decide filename on runtime. Can you tell us ?

Regards
Sreeni

kumar_s wrote:If its about deciding filename on runtime, then YES, its possible on many ways.

Hi Srini,

Do you mean that passing values (file names) at run time. If yes, you can follow this way:

1) Choose Edit-->Job Properties-->Parameteres
2)In the dialog box you can create your new parameters and also you can assign default values to them.
3)Assign those parameters to the stages.
4)You can pass the values to those parameters at run time ie whil clicking run button it will ask all the parameter values, so that you can pass your values(file names, table names etc.,) at run time.

Hope this is your expectation.

You can let us know, on what basis the filename should be decided. So that the method can be decided.

m903782 wrote:is there any way to reach the name of the file when you work on it in datastage

Hi,

First clarify your requirement. Other wise, here so many assumptions are going on.

You mean you want to pass the file name as parameter ? ( One more assumption )

Ok OK ... i am not clear
the problem is the following.


I have to to know the name of the file wich i load in the datawarehouse.

But i am working in a society wich does not accept to use dynamic parameters. i have to deal with.

before, il launched my job or during the laucnhing, is there any way to know the physical name of the file without using any dynamic parameters.

really thanks for you help.
javascript:emoticon(':P')
Razz

thebird wrote:There is also the File Name option in the Sequential file stage which lets you have an additional column in the metadata with the file name as the value inside.

If you need to know the file name at the time of loading why cant you use the above option?

Aneesh