DSXchange

Hi All, I have two dataset in my prod job and doing left outer join based on the column(GL_PROD,GL_ACCT). The key columns datatype is Decimal. After completing the run, out of two records only one record was populated into target datset even though key column values are matched. Due to that,unable t...

Hi All, Our jobs are running in production past 3 years without any issue. Today one of the job got failed due to below captioned reason. Not sure why it got failed. Kindly advice on how to fix this issue. Aggregator_198.lnkFund_Sort,1: Fatal Error: waitForWriteSignal(): Premature EOF on node PM094S...

Hi All, One of my job is production taking more than 3 Hrs 50 min to load the data into the data set. The design is very simple 1. Incremental source file extract the records having 21 million records from sequential file to load the data into data set. 2. The above loaded data set having look up wi...

Hi All,

Today when I run the sequencer, one of the job got below mentioned warnings.

"DataStage Job 176 Phantom 5764 Program "DSD.ODBEvent": Line 1519, Could not locate NLS map . DataStage Phantom Finished"

Can you tell me how to fix this warning?

Thanks for your reply.

In datastage metadata I have defined for that source column Decimal

(15,7) and my database is SQL server.

Hi, In my job one of the column name data type is Decimal(15,7). When I view the data in DB data comes in proper format like below COLUMN NAME ---------------- 2003.0000000 But when try to view the same column (data type is Decimal(15,7) ) in datastage data comes in below mentioned format. COLUMN NA...

Thanks for your input. Your input will work only in parallel. I am working server 7.5. Please let me know how to do the same in server

Hi, In one of my job my date format like below 2011-07-03 2011-08-03 2011-09-03 2011-10-03 2011-11-03 Now I need to compare the data between the current and previous data. I need to take first row date(2011-07-03) as my start date and the next row date need to load as a end date before that I have m...

I fixed the problem. Now job is running fine. I changed the NLS setting to "NONE".

Thanks to everyone.

Chulett, Why I asked for looping concept, I have to implement the same logic in another job and source table having 60 columns. It is really difficult for me to implement having 60 rows in the same job. That's why I asked how to implement the same logic using loop variables. Need output is: 1,2,3 2,...

Really thanks for all your valuable input. I am using version 8.5 and loop logic is really new for me. Can you help me how can I implement this logic using loop variable.

I have 6 columns in the source table with data as follows. Source Data: COL1,COL2,COL3,COL4,COL5,COL6 A,B,C,D,E,F The output should be A,B,C B,C,D C,D,E D,E,F E,F,NULL F,NULL,NULL The output will have only 3 columns. The data should be like this. First row: first column, second column, third column ...

Hi All,
I need to implement one of the logic in my job. In the source table having 6 columns in one row and that row I need to be pivoted like I mentioned below.

Source table:
col1,col2,col3,col4,col5,col6
1,2,3,4,5,6

Output:
1,2,3
2,3,4
4,5,6
5,6,null
6,null,null

Any help is really appreciated.

My source column data type is String and I am reading from the SQL Server.

Thanks for your response.

I am receiving some data's are in below mentioned format

May 9 201 12:00AM It should be May 9 2011 12:00AM.

Like I mentioned above If I have any bad timestamp , I need to reject that data.