DSXchange

Hi, You could use pivot SQL to achieve the output if you can stage the data in database. Please see the SQL below (SQL Server based): select account,currency, isnull(Investment_Retail,0) as Investment_Retail, isnull(Equity,0) as Equity,isnull(Group_Liquidation,0) as Group_Liquidation from ( select a...

Ok..There seema to be a liitle change in requirement.Check this one select column1,column2 from( select column1,column2, count(distinct column2 ) over (partition by column1) as cnt1, count(distinct column1 ) over (partition by column2) as cnt2 from table) where cnt1<>1 or cnt2<>1 order by 1,2

you can try the below query.

select column1,column2,
count(distinct column2 ) over (partition by column1) as cnt
from <<table>>
order by 1,2

and then filter by 'cnt' not equal to 1

Hi, Here is my thought on the scenario. 1)sort the data by header 2)Genererate seq num based on the repeatitive header 3)Get 3 links out of the transformer to 3a)get max of the genereted seq num & add dummy column 3b)remove duplicate header and then add dummy colum & generate row num again u...

Hi Is there way to get the Value File Name from the choosen ParameterSet. for ex psSourceDB is the name of the parameterset and the value are shown below Region1 xxx yyy zzz Region2 aaa bbb ccc Region3 eee fff ggg where Region1,Region2,Region3 are the value file names. I need to capture the value fi...

Thanks Sainath.
It works fine with Oracle 10g client.

Hi, We have recently installed IS on 64-bit Red Hat Enterprise Linux 5 Advanced Platform. Oracle client used: Oracle 11g Release 2 (32 bit) I'm getting the following error while installing Oracle Library :/opt/IBM/InformationServer/Server/DSComponents/install> ./install.liborchoracle Installing Orac...

Thanks ArndW and Ray for your help.
I'll check with IBM support.

Thanks ArndW. I checked the NLS setting in DS Admisnstrator.It is set to ISO8859-1 Not UTF-8 Is there any other settings I need to check? Also I check some other post where Ray has mentioed: With NLS enabled, data (including design information, etc.) while within DataStage are stored in an idiosyncr...

Thanks for the reply Ray.

I checked the NLS setting at the project level.It is set to ISO8859-1

check the below output from OS.

echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1

Can you please let me know where exactly I should change the settings.

Thanks

Hi Currently I'm upgrading DS 8.0.1 to DS 8.1 When I tried to upgrade to DS 8.1,I got the following message. EDataStage31043:The IBM Websphere Datastge 8.0.1 installation you are attempting to upgrade has NLS enabled and your system is currently configured for UTF-8.Upgrade is not supported in this ...

Another possibility is that your row size is larger than that declared - or, perhaps, permissible - in the bulk loader. ... Ray,Thanks for the input. The Bulk load works absolutely fine for one table wherein i'm inserting 1.7 millions records.Totally there are around 6 attributes in the table. But ...

Hi All, I tried loading data from a flat file to SQL server using SQLBLK7 Bulk loader stage.I got the following error message. Internal error: Failed to allocate row buffer memory. Failed to prepare fast load session. Is this something to do with DataStage or Sql Server DB? I searched the forum,coul...

Hi all, I have a doubt regarding binary datatype in SQLServer. Here is the scenario. I have my source data in sequential file(comma delimited) with two columns user_id int(4) and user_pwd varchar(50). Sample input data: 1,0x3055D2E2DAD6F9E8C41126A95DABCDD4 Now I have to insert the records into SQLSe...

Hi Arjun, Try this.... 1)Read your data in a sequential as a single column(c1) with demiliter specified as 000 2)create a stage variable svPivot and use this code Ereplace(DSLink2.c1,",",char(10):char(13):field(DSLink2.c1,"|",1):"|") -->svPivot 3)write the stage variabl...