DSXchange

I am using DataStage 8.7 version...

yes, ';' is the delimiter to divide the column and also C2 is not fixed length.

my input is like : C1 C2 --- ------ 123 ABC;DEF;GEH Output : C1 C2 C3 C4 --- ------ ----- -------- 123 ABC DEF GEH Thanks in advance

Parametrise Previous Date,FUTURE DATE in your job and add below constraint in transformer.
EXPIRY_DATE>= Previous Date and EXPIRY_DATE<= FUTURE DATE

Can you elaborate your question with some source data...

Hi Prasoon Da,

I designed the job in Datastage v8.7 ,So i have not added DATASTAGE_JRE and DATASTAGE_JVM in my job.

DataStage Web Services Client stage fails with below error: Web_Services_Client_1,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1602) at com.ascentialsoft...

Job design in DS v8.7: Web_Services_Client-------->>peek DataStage job is aborting due to Below error: Web_Services_Client_0,0: Fatal Error: Fatal: TJClient::initialize: unable to create Java Virtual Machine; classpath = /opt/IBM/InformationServer/Server/DSEngine/java/lib/wsclient.jar /opt/IBM/Infor...

Source column Datatype is Varchar(16) and Data is coming like D3476654765 766546799989G 87978675436L And Target Column Data type is Decimal(20,0) I am doing Type conversion StringToDecimal(Src.Column) This function is not handling this column and getting warning as "Conversion error calling con...

Write two filter conditions

1)filter on Key change column =0 which gives duplicate records.
2)filter on Key change column =1 which gives unique records.

Thanks Eric

i am using datastage 8.5 version

Hi,
can anyone please tell me the logic to implement this scenario...


my source is coming like,

id
---
2
5
3

and target is,

id
---
2
2
5
5
5
5
5
3
3
3


Thanks in advance


Regards,
------
Thiru

can you please tell me the logic in 8.5?

Hi All, I have a scenario like this, source is coming like, id , Dept , value ----------- --------- ------ |10|13|15| , abc , 15 Desired output is, id , Dept , value ----------- --------- ------ 10 , abc , 15 13 , abc , 15 15 , abc , 15 Can anyone please explain the transformer loop logic for Datast...