DSXchange

Hi Folks So its been almost 9 years working on different versions of Datastage and gaining a lot of understanding on Data Modelling stuff. I am now thinking of using all my experience and expertise to jump into the bandwagon of ETL Architect / BI Architect / Datawarehouse Architect. However , I woul...

DateToString(DSJobStartDate,"%dd-%mmm-%yyyy")

I used DSJobStartDate as an example, you can substitute it with your input date.

Try reducing the Array Size value to 1

http://<servername>:9080/ibm/iis/console/loginForm.jsp?displayForm=true

If you login to administrator, you will find a link at the right bottom corner namely "Suite Admin". Clicking on it will also take you to the web console.

Is Joined_DATA_200 an input link? Can you share the metadata of the input link?

It is beautifully explained in the below pdf.

http://www.redbooks.ibm.com/redbooks/pdfs/sg247987.pdf

In case if "User Variable Activity" is used in a sequence then Oconv,Iconv functions can be used

Try using Oconv,Iconv functions

A quick google search fetched me the below link.

http://www-01.ibm.com/support/docview.w ... wg24032115

Thanks for the link Vincent!

LastRowInGroup function does require the data to be sorted. "A key break can be detected on any column, as long as the input data has been sorted on that column. The data must be sorted in the job, so that the Transformer stage can detect that it is sorted. If the data is sorted before being in...

hmmm i tried exactly what you have coded and in my target table (created on Netezza), I am not seeing any "??" suffixed in the data.Also, i didn't make use of APT_STRING_PADCHAR in my job.

You can try something like this :- Before populating the data into Teradata, use a case. Within the case , cast the said column into varchar and check for its last three substring values (and may be another cast is required to integer for comparison) if it's greater than 499. If it is greater than 4...

Can you try using "APT_STRING_PADCHAR" in the job and set its value to 0x20

I created a sequence (no environment variable used) with only execute command activity and passed the following command (under the command option) in it :- echo "Overtime Reporting/Cubes" Output --> "Overtime Reporting/Cubes" Then, Passed following under command option - echo Pas...