DSXchange

Hi All,

Could you please tell how to restore the datastage project in unix server.By mistakes all datastage installation directory is deleted.


Thanks in adv

As per the requirement, it will be fine for me

Thanks Mohan,

I used StripWhiteSpaces() and it worked fine.

If StripWhiteSpace(Col1)<>StripWhiteSpace(Col2) Then Trim(Col1) : " ":Trim(Col2) Else Trim(Col1)

Thank you all

If I use single words as column values, then the condition is working fine. But when I use values like 'Air Conditioner', 'AC Service', then transformer treats them as different.

How can i remove the spaces in between the values.

One thing I forgot to tell the strings are having spaces in between.

Eg: Air Conditioner

But both the column values are same with the spaces also at the same position. Then also it is considering them as different and concatenating.

Thanks for the reply

I am using the same condition.The columns are getting concatenated even if they are same. They should be concatenated only if they are different

Hi All, I have a requirement to compare 2 columns and if they are same then print the 1st one. If both are different, then print the 1st concatenated with the 2nd. Eg: The 2 columns are: Col1 Col2 Air Air Water Air In the 1st case Col1=Col2, so the output should be Air In the 2nd case Col1<>Col2, so...

if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 or OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4

Now the job is getting aborted if I am trying to insert records with duplicate values for the primary key into a tablebut the records are getting inserted and auto committed. And the primary constraint becomes disabled. What should I do so that in case of primary key violation, the records should no...

Give Null Field Value as "" instead of Null Field Length.

May be this can be of little hepl to you

This warning comes with option Explicit keys and values for all the columns which are not used as a key or a value in CDC. If your requirement permits,use a copy stage between your source stage and CDC and pass only those columns which you require for change capture. Else use the option Explicit key...

Thanks for the reply. I have set the PXEngine library path. Now it is giving another error: ##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc. ##F TFCF 000009 Fatal Error: Cannot continue without a configuration file. $APT_CON...

Pass (max(col)+1) as a job parameter and then use this parameter in Surrogate key Generator. Give the start value as the value of this parameter.

Hi All, I am trying to view dataset from unix using the below command: orchadmin dump output.ds This is giving error: ld.so.1: orchadmin: fatal: liborchgeneralsun4.so: open failed: No such file or directory Killed How should I give the orchadmin command so that I am able to view data from dataset? T...