DSXchange

I am currently into a critical assignment. Where i need to load data from source to target using datastage 7.X Source and target being Oracle. My Table Structure is a below for Source, EMP_SRC EMPNO_SRC ENAME_SRC My Table Structure is a below for Target, EMP_TGT EMPNO_TGT ENAME_TGT I Used Transforme...

"/dsetlsoft/datastage/Ascential/DataStage/Datasets" has a free space of 39GB

In temp directory

Login as Root Step 1: cd /dsetlsoft/datastage/Ascential/DataStage/DSEngine/ Step2: ps -ef|grep dsrpcd Monitor shoould show 2 Enteries root 1277968 1 0 18:06:35 pts/2 0:00 /dsetlsoft/datastage/Ascential/DataStage/DSEngine/bin/dsrpcd root 1364202 921618 0 18:06:45 pts/2 0:00 grep dsrpcd Step3: ./bin/u...

WHICH OPERATING SYSTEM ARE YOU USING? IS IT UNIX?

we have 40GB free space over there

I HAVE AROUND 33 LAKH RECORDS IN MY REFERENCE TABLE

I have designed a lookup job. When I try to execute that job Iam getting the following error message "LKP_AL_YES_COEP,0: Could not map table file "/dsetlsoft/datastage/Ascential/DataStage/Datasets/lookuptable.20070613.ujo03nc (size 1733722784 bytes)": Not enough space Error finalizing...

I have a table with the following data in SQL SNO NAMES ------ ----------------- 1 prasanna 1 lakshmi 1 Ravikumar 2 raja 2 lakshmi 2 natrajan 3 deepika 3 bidri 3 G And I need the output as following using SQL query SNO FNAME MNAME LNAME 1 prasanna Lakshmi Ravikumar 2 Raja Lakshmi natrajan 3 Deepika ...

I have installed Oracle in my system as well as datastage. Oracle is working properly with Datasource name "Ora", username "scott". But when I use OCI stage in Datastage and when I try to connec to database with same DSN ........Iam getting an error message " TNS name couldn...