DSXchange

1)I hope The default date format is yyyy-mm-dd in your project and If you need some other format use DatetoString function but the output will be of type string type.

1)Extract first two characters and check whether it is 91. If it is 91 extract n-2 right most characters and append with 0

Use string functions,if clausesub string operator

How and where to check the value of the environment variable from the operating system of the job environment when we use $ENV for DataStage environment variable? $ENV Causes the value of the named environment variable to be retrieved from the operating system of the job environment. Typically this ...

Could any body please explain how it will work?

Custom trigger:
Code: Mod(@DATE,7) <= 1

Because @DATE will give Date how can we can divide date by 7?please correct me if i am wrong?

Thanks ray for u input.Cluster is clear now.Is there anyway to identify the Grid based on fastnames or something else from configuration file ?

Compiler is not necessary in the following cases

1)If u are not using any parallel transformer in job

2)If the user does not want to change anything in the Job because if the user change something user need to compile the job.

I think we can compile the Sequence jobs without C++ compiler

In a configuration file if the fastname is same for all the nodes then it denotes SMP.Could anybody help how me to find it out the Cluster and Grid configuration form the configuration file?

Could you please clarify below doubt.

Suppose If in a single Job we are using both english and Arabic data ,which NLS Settings we have to use and also could you please explain why you selected the following NLS(with 'ISO8859-6' and 'UTF8').

You can also try below command on unix prompt


dsjob -linkinfo <project> <job> <stage> <link>

123gopal wrote:That information is confidential.........
sometimes pass the value in that particular variable.............
so no need to get that information........

Could any body please elaborate on the above point?

Is it possible to see that value at system/OS enviorment variable?

when the enviornmental variable is set to $ENV,from where it will pick the value whether it is from configuration file or enviornmental file or something else?

Thanks for the input.Could you plese clarify below doubts?

1)I did not find any option in Lookup Stage to select the sparse Lookup property?Could you please help me where to select that property?

2)Why should not we use Sparse lookup for sequetail file stage?

I read Sparse lookup can be used only when the reference link is Database.Just want to know if it can be still used if ref link is sequential file?

In version.xml it is showing InformationAnalyzer is installed but not able to find any client component .Could anybody throw some light how to access the InformationAnalyzer? <Products> <Product productId="metadata.server" version="8.5.0.1"/> <Product productId="DataStageCom...