DSXchange

Hi , I have a following scenario. Input: ID|NAME|DT 100|AAA| 2.0;300.90;09/23/2009;12/20/2007;00.65;24;04/10/2008;0; 101|BBB|04/22/2005;30;78 102|CCC|0;24.50;90; 104|DDD|45;11/02/2009;90;03/23/2009 Required output: ID|NAME|DT 100|AAA|09/23/2009;12/20/2007;04/10/2008 101|BBB|04/22/2005 102|CCC| 104|...

Hi , I have a following scenario. Input: ID|NAME|DT 100|AAA| 2.0;300.90;09/23/2009;12/20/2007;00.65;24;04/10/2008;0; 101|BBB|04/22/2005;30;78 102|CCC|0;24.50;90; 104|DDD|45;11/02/2009;90;03/23/2009 Required output: ID|NAME|DT 100|AAA|09/23/2009;12/20/2007;04/10/2008 101|BBB|04/22/2005 102|CCC| 104|D...

Hi,

I have 2000 jobs in 35 main categories. I know the output file name. But I want to find the job name which is creating the file.
Is there any way to find or mannualy we have to search it...


Thanks in advance
Parameswar

You would seem to have run out of total virtual memory on your machine but starting that many datastage jobs and processes. If you increase your swap space you will probably get rid of these errors but chances are quite good that your performance will be abyssmal. You can look up "out of proce...

Hi , To test maximum loads in DataStage server we executed 8 sequences in parallel where total number of jobs is around 70. Here all the jobs failed with the below errors: StgRejExpCodes,2: kgefec: fatal error 0 OCI-21503: program terminated by fatal error OCI-04030: out of process memory when tryin...

Hi ! I installed datastage without any problem as root user. After Installation I tried to connect through designer, But got the bleow error: " Failed to connect to host: hpus51, Project UV : (The connection was refused or RPC daemon is not running (81016)) " Then I tried to stop and start...

Does this connection string include a correct reference to an entry in the tnsnames.ora file? Hi, Connection string is correct. It is working fine if we will pass value, it is working. The same parameter is working in Oracle stage aslo. But it is a surprise taht DRS stage is not taking this paramet...

:idea: Here's a "trick" so that you can use the "Insert Job Parameter" helper. Right-click on the DRS stage and select Grid Style which is the old way you worked with the stages. Switch to the Properties tab and then use the Insert Job Parameter tool to populate your connection ...

Is this through ODBC and, if so, what is the total size of the row? There is a tunable limit (MAXFETCHBUFF) to row size in Data Direct ODBC drivers. Hi Ray, I am using ODBC to extract data from SQL server. Last characters are truncationg from few fields, not from all fields. Could you please help m...

OK, we've proven that the SQL is being passed to the job successfully. The next step is to establish that the SQL is being passed from the job to Oracle. You will need to enlist the help of your DBA to monitor the connection and record the SQL that was actually received by the Oracle database serve...

chucksmith wrote:Could this be a data type issue, such as moving a CHAR column to a VARCHAR column?

Hi,

Even if I am changing datatype from char to varchar , I am missing one character from last of the column . Is there any other reason for this truncation...

Thanks,
Parameswar

Do some debugging. Find out what was actually passed. Job parameter names must be correctly spelled and correctly cased in order to work properly. Further, they must be enclosed in a pair of "#" characters when used in passive stage types. Did you type the job parameter reference in your ...

Hi, My job is aborting with below fatal error if I am using Connection details as parameter in DRS stage. Fatal: ORA-12154: TNS:could not resolve the connect identifier specified. But if I will hardcode the log in details in DRS stage it is working fine. Is there any solution to pass user id/Passwor...

Hi, We are extracting data from SQL Server using odbc stage. In datastage we are getting data , but from few fields it is truncating one or Two characters. If we will extract data by appending one or two character, we are getting correct data in datastage Example: Instead of RES_CODE if we will retr...

OK, we've proven that the SQL is being passed to the job successfully. The next step is to establish that the SQL is being passed from the job to Oracle. You will need to enlist the help of your DBA to monitor the connection and record the SQL that was actually received by the Oracle database serve...