DSXchange

Still there is no option to insert parameter value but if u give #prmTargets#/sampleout.xml the target file name will be parameterized.

I have done in this way.It works.

Thanks
Shaonli

In the lookup use CONTINUE in lookup failure condition so that u pass record when there is mismatch also.Now next to lookup use transformer check whether the field extracted from reference link is null ornot.If it is null then put ) else the field of Ref link.

Thanks
shaonli

Yes sorting is required because grouping will done as records appears to that stage.By sorting data it will work.It worked in my job.
Thakns
Shaonli

Please check the box Repeatation element required in XML Output stage and Set SecurityId as key.
It will work.

Thanks
Shaonli

Please check the box Repeatation element required and Set Security_Level_Id as key.

The same thing as described by Santanu has happened in my job. In ODBC COnnector stage in Properties in Connection option we need to give value in Data Source,Usename,password. When we are giving hardcoded value and testing the connection it gives that Connection is fine. But when we are inserting p...

Yes it has been possible by passing paramter outside DSsend Mail routine.The Argument is passed from Unix script.
in the argument if routine I am giving that value as Command Output.

So it has been possible to parameterized.

Thanks a lot..
Shaonli

Yes it has been possible by passing paramter outside DSsend Mail routine.The Argument is passed from Unix script.
in the argument if routine I am giving that value as Command Output.

So it has been possible to parameterized.

Thanks a lot..
Shaonli

Sorry the job is Parallel

Hi, I want to attach a file in mail which I am sending from Datastage.I am using DSsendmail Routine. There When I am explicitly giving Attached file path then the file is going in mail. But when I am using Parameter in file path it is showing Cannot open file. Arg: "From:me@here\nTo:you@there\n...

What is the significance of qsweight in reference match stage. how it calculated

What is the formula to calculate qsMatchWeight in frequency match stgae.

And how to fix the cutoff value for clerical view

Do i need to give Weight Override, and Cut off values

I have taken two column from two seprate files to compare through reference match stage.

I have used CHAr comparision with m prob as 0.66 and u prob as 0.33
I have only one column in both the files and i have not used the block command.

What is parameter which need to be defined

what is the significance of these in reference match stage

qsMatchWeight.
qsMatchPattern.
qsMatchLRFlag.
qsMatchExactFlag.
qsMatchPassNumber
qsMatchDataID
qsMatchSetId
qsMatchType