Hi Guys,
I looking for the statement
Table : TIN_IRxxx_MXXXXX
Field Name : IRXX_TiXXXX
Rules : valid Rules= Mr,Mrs,Miss,Ms,Dr,Prof,Adv,Rev
when title : Mr,then Sex= male
when tiele: ;Mrs’ or ‘Ms’,or ‘MISS’ then Sex =female
please give the Select statement for the above.
regards,
vsu
vsu (BOB member since 2012-05-15)
And what do you think that it should be?
Johannes Vink 
(BOB member since 2012-03-20)
And are you doing this in the Information Steward?
ganeshxp 
(BOB member since 2008-07-17)
yes,
source system is Oracle . write the validation rules in IS.is it possible to write select statements in data insight. is there any answer to my query.
regards,
visu
vsu (BOB member since 2012-05-15)
Hi Visu
What is the issue here ?
I think you do not need SQL here. All you need is to verify whether values are one of you mentioned or not, based on that rule (validation) would pass or fail.
As far as SQL is concern you can write SQL also using decode function but where are you going to put this SQL?
Thanks
softsys (BOB member since 2005-05-13)
Hi everyone,
I’m with a table that contains 2 fields, field A and field B. Duplicate values over field A are ok and allowed while field B can only store one constant character X goes by field A. That’s why I want to build a rule to check and the rule needs to be built in SAP information Steward. So I wonder if Information Steward can recognize and execute a SQL statement like this
SELECT TABLE NAME
SELECT FIELD A, FIELD B and FIELD C. (field C is used to store count value)
Count FIELD B by FIELD A and store the count in FIELD C
IF FIELD C <> 1, output records
otherwise end.
I am looking for a SQL syntax or clause to perform the check logic against the table said above. Any thoughts? I appreciate.
by the way, it is SAP Hana Data Base table. I heard SQL clause varies by DB.
Yaofei
Table.txt (0.0 KB)
yoffeyluo (BOB member since 2018-10-08)