DSXchange

Dear All, Job Description: Dataset --> cpy---> Oracle stage Method: Load Append Partition Type: Same Index mode: Rebuild Node: 4 nodes Disk space: 30 Gb While the amount of data is around 593708 - This job run fine While the amount of data is 3742694 - the job aborts with the following message Error...

I am facing design issue in datastage I have one source table ADDRESS and 3 target tables CUSTOMER, CONTACT and AUDIT tables. customerID is the key column in source and target tables. For each customerID in ADDRESS table, I have to update one record in CUSTOMER and to delete one record in CONTACT an...

TargetName = lookup_string_from_int16[{default_value = 'N'} (2='Y';)](SourceName)

This is what i tried but failed...

Hi all My Requirement to be done in Modify Stage IF input_column='2' THEN 'Y' Else 'N' Input column is Integer Target column is Varchar I have gone through the Posts and Found lookup_string_from_int16() and lookup_int16_from_string() functions According to my understanding , I understand that we ca...

This is the unix script that I have written. Length of RBX_PROJ_NAME varchar2(3). CONNECT_ODS=$1/$2@$3 sqlplus -s <<EOF $CONNECT_ODS INSERT INTO RBX_LOG ( RBX_PROJ_NAME ) VALUES ( 'RBX' ) / exit EOF In Datastage, I am using Execute command to run this script and Trigger is set to OK-(Conditional) 1....

"Even if I change the name of TNS_ADMIN to ACD_AMIN it still works.. "

sorry for giving a above false statement.
Only if I give TNS_ADMIN it works and not ACD_AMIN.

Not the same case for me, but might help 1. In my case I created an entry in the tnsnames.ora using the login I use to login to DataStage and to Unix (for example in the following path apsdev/app/tnsadmin etc) 2. when I used the SQLPLUS option in UNIX and gave username@SID and password, I was able t...

You did not understand clearly. And your script is working correctly assuming you want the O/S user rather than the logged in user/schema name. Well I am sorry, I did not understand you. To be clear, I have logged on to the user=cmtapp and password=xxxxx. In the $HOME path, I have a file tnsadmin/t...

you should explain the detail functionality of that script, whether cmt.cfg is static or generated on run time, the script name is a.sh and has the following echo $CMT_ORA_USER echo $CMT_ORA_PWD echo $CMT_ORA_SID cmt.cfg is static or does not change in any point. I have keyed in manually the inform...

If I understood clearly, this should not be dstage but cmtapp user.
How can this be rectified?
I am not a Admin person, however I would like to know if possible.

To be exact Log from Director: USER=dstage BCS_ORA_PWD=LD;@1IVHN9BN0G7I<:J51K04F<>IM1 BCS_ORA_SID=r1d1c BCS_ORA_USER=bcs_adm CMT_ORA_PWD=LD:@0;VH=9BN0GFI<KJ<0K04F<>IM1 CMT_ORA_SID=r1d1c CMT_ORA_USER=cmt_dat env from Unix user: USER=cmtapp BCS_ORA_PWD=bcs_dev_01 BCS_ORA_SID=bcs_dev BCS_ORA_USER=bcs_a...

I have a unix user named:cmtapp I wrote a script in which i echoed the username, password and SID of a oracle database Note: tnsadmin is setup good. It displayed the correct values which where in the cmt.cfg file (cfg file contains all the variables like username, password and SID of a database). Wh...

Oops sorry one sec late....... :D

Each Job Activity stage in sequence has a Execution Mode.
You can set it to "Reset if required, then run".
This will take care in any job fails

I just run a sample job in that i gave job parameter as Bizdate as Date datatype and value as 2010-10-10 if i type a wrong date it does not accept Biztime as Time datatype and value as 05:05:05. I used a row generator to generate 10 rows and passed these parameter to target date and time column resp...