DSXchange

Hello, We have a scenario where same job is used to load two database tables in different environment (for disaster recovery). We have used parameter set & have created parameter value file to achieve this. For now we are passing $PROJDEF for SYSA & hardcoded values for SYSB parameter. Param...

Hello, We have received source file having French character. Our job is a simple job Read File => Transform => Load Teradata We have used NLS at Job level as ASCL_ISO8859-1. In Teradata connector we have used client character set as UTF-8. When I run the job, French character data gets processed suc...

Hello Experts, Need your help. We have a requirement to process data which contains German character from Teradata to Oracle Teradata (API/Enterprise) ---> Transformer -------> Oracle Enterprise NLS (AMERICAN_AMERICA.WE8ISO8859P1) NLS (UTF8) (ASCL_ISO8859-1) While running the process Source system i...

I need help. One of Our Production started failing recently for issue - Access logging step has failed. This job reads data from Teradata Staging table we do some transformation after that we upsert data to four different tables. These four tables are all reference tables (Dimensions). For all four ...

Hi we have a requirement where we need to load data from web page (ex google spreadsheet or Currency exchange example
http://www.bloomberg.com/markets/currencies/fxc.html
)

will you please help if there is a way to load these data automatically through some job/script.

Thanks,
Bhaskar

Hi, I have a job which fails regularly on weekend, but its running fine over weekdays. ODBC => Transformer => TD Mload We have two target table stage on Output. Though there are no rows to fetch Job is running for 25 min & fails with above error. Please help if we need to set some parameter at a...

Hi,
Basically the issue is because you do not have permission on Assential folder reqired by Quality Stage. Get full permission on C:\Ascential & it will not give any issue, or otherwise log to your system with administrator credential.
Thanks,
Bhaskar

Hi,
Basically the issue is because you do not have permission on Assential folder reqired by Quality Stage. Get full permission on C:\Ascential & it will not give any issue, or otherwise log to your system with administrator credential.
Thanks,
Bhaskar

No Ray, Where can i create the profile. What is the use of Datastage xpsp2 patch Have you been able to get as far as creating a profile? Is there any else to this message, or any other message? Do you have the DataStage xpsp2 patch installed? ... Hi, Basically the issue is because you do not have p...

Hi All, I am unable to read data from database using Teradata Enerprise stage the error which I am getting is TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863] DBCAREA msg_txt: MTDP: EM_CHARNAME(227): invalid character set name specified. [terautils.C:2864] <Stage Name>: APT_TeraUtils::con...

Hi, I have a job which reads data from a staging table (Odbc stage) & loads the data to target Teradata table (Teradata Multiload). ODBC-(Source)-->Transformer-->Teradata Multiload(Target) In target stage we have delete in before sql & update in after sql. These delete & update are on th...

Hi, I have a job which loads a table by using Teradata mulload stage. My job looks like ODBC stage--> Surrogate key Gen--> Transformer---> Teradata Multiload I am getting following error while running the job. <Link_name>,0: Failure during execution of operator logic. <Link_name>,0: Fatal Error: Fat...

Hi, We have Datastage V 7.5.2 installed on Windows. We are able to run job with file stage. We have created a local Teradata data base, We are able to login to this database. But we are not able to connect to this DB through Teradata API stage. The error which we are getting is "Unable to conne...

You can create a sequence as required then you can run this sequence, by using dsjob utility. Once you enter the command with dsjob in a script. you can make a crontab entry to schedule this script. Alternate way is just create a simple job (flat file) to (flat file), then call this script in this j...

Hi, My Job design is (Source (DB2 table) with some lookup) ---> Agreegator ---> Target (DB2 table). I am facing problem while aggregating the record. Approximately I have 2.5 lacs record in Souce table. While running the job I get following Error mesg [IBM][CLI Driver][DB2/AIX64] SQL0912N The maximu...