DSXchange

I m trying to run the Ds job through Reference_MAtch stage .
i have to compare two columns(data and reference) and get the percentage of match for all the records.
But i am receiving as FATAl ERROr as "main_program: Fatal Error: Field not found: keyChange"

Can anyone suggest on this .

You can achieve this by using Index function which finds starting character position of substring.
Target=Inputcol[1,Index[Inputcol,'A',1]].
Please try this

Thanks
Shaonli

After pivotting the i/p I got Input_Value,ID(which I added),Attribute "TIGERPRINT","2","OWNING-GROUP" "4","2","OWNING-GROUP" "0","2","OWNING-GROUP" "TIGERPRINT1","3","SECURITY-LVL"...

According to your suggestion I have pivoted the recors.After pivotting I am getting 9 records. Then I am using the Xpath as /RECORDS/RECORD/PROP/PVAL/text() The o/p is <RECORDS> <RECORD> <PROP NAME="OWNING-GROUP"> <PVAL>TIGERPRINT </PVAL> </PROP> <PROP NAME="SECURITY_LVL"> <PVAL>...

Hi My I/p is
Id name sal
1 A 1000
2 B 2000
3 C 3000

O/p is
VAL
1
A
1000
2
B
2000
3
C
3000

since I Don't have any key on which basis I can do pivoting.SO how will I configure pivot stage.
Please suggest.

Thanks
Shaonli

Sorry Ray.....
If it is possible then please provide the solution for it.

Thanks in advance
Shaonli

Can you please explain this more explicitly.
This is an urgent requirement.

Thanks In Advance
Shaonli

My i/p has 3 columns.I/p is--- OWNING GROUP SECURITY-LVL GROUP-NUMBER TIGERPRINT 4 0 TIGERPRINT1 5 1 TIGERPRINT2 6 2 Expected o/p is <RECORDS> <RECORD> <PROP NAME="OWNING-GROUP"> <PVAL>TIGERPRINT</PVAL> </PROP> <PROP NAME="SECURITY-LVL"> <PVAL>4</PVAL> </PROP> <PROP NAME="GR...

Please check the character set.In my case also when I was using Compex file stage for reading cobolfile ftp ed from M/F server,the binary data was viewing until I change the character set to ASCII.
So please check it.

In my job I have the same file checking condition.So I have called a UNIX script from execute command stage with filename as parameter. From script you need to return value.The script will look like below one in_dir=$1 in_file=$2 if [ -s "$in_dir/$2" ] then exit 0 else exit 1 fi Now in tri...

Hi, In my job after using standardize stage (USNAME rule set) I want to use match frequency stage.So after standardize stage I am using a transformer(according to Quality stage tutorial) where I am creating a column named MatchFirst1(Varchar1,Nullability yes). The derivation of this field is If isNu...

Please check your script.Sometimes command o/p does not work.It happened with me.You can give use the RETURN_VALUE option of the script in the trigger.

Thanks
Shaonli

When no of connection to database from Datastage server increases the job gets aborted due to this fatal error.Please check whether you are able to connect database from datastage. This happens due to connection problem. It happened with me when DB2 tables ere used in lookup . Please check the conne...

When no of connection to database from Datastage server increases the job gets aborted due to this fatal error.Please check whether you are able to connect database from datastage. This happens due to connection problem. It happened with me when DB2 tables ere used in lookup . Please check the conne...

When you are using lookup file set in lookup stage you will not get option to select key.yoy need to specify the key (that the lookup on this file set will ultimately be performed on) while creating the lookup file set. You can repeat this property to specify multiple key columns. You must specify t...