file name

m903782 · Post by **m903782** » Mon Dec 04, 2006 1:23 pm

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

narasimha · Post by **narasimha** » Mon Dec 04, 2006 1:27 pm

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.

thebird · Post by **thebird** » Mon Dec 04, 2006 1:44 pm

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.

kumar_s · Post by **kumar_s** » Mon Dec 04, 2006 7:14 pm

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

Sreenivasulu · Post by **Sreenivasulu** » Mon Dec 04, 2006 10:37 pm

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.

BalageBaju · Post by **BalageBaju** » Mon Dec 04, 2006 11:09 pm

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.

kumar_s · Post by **kumar_s** » Tue Dec 05, 2006 2:52 am

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

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Dec 05, 2006 4:27 am

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

)

m903782 · Post by **m903782** » Tue Dec 05, 2006 2:50 pm

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 · Post by **thebird** » Tue Dec 05, 2006 2:53 pm

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

DSXchange

file name

file name

Re: file name