DSXchange

Hi,

You can also do a thing.Create an XSLT to convert the xml file after aggregateing if not in proper format to required format.And use that XSLT to create the xml file using xml transformer stage.

XML transformer stage is used to convert one type of xml to another type.

anujgarg wrote:Hi,

Santosh have you tried aggregate all row option ?
I think it may solve your problem.

Don't keep any column as key column.Then try aggregating all rows.
Plesae post the updated xml format you got after this.

Hi,

Santosh have you tried aggregate all row option ?
I think it may solve your problem.

scorpion wrote:can any one please respond !

Can we supply the dsn information for this table in different database or it needs to be created in teradata itself.

Have you tried with dsadm? It is not necessary for datastage to use the same aproach we use to access the dataset. I don't have access to tha.Client hasn't provided us the dsam id.Any other thing problem is there in script?? Can i delete the datset file by deleting both descriptor and datafiles dir...

Basically it should work. What is the user id you use? Try with dsadm. If that works, issue is sure with the permissions. Is it possible that these files doesn't have object files attached to that. Another thing Whatever may be the problem then how the dataset managment tool is able to do all the a...

kumar_s wrote:Have you check with the permission of those files.

It is having only read permission for all groups and users.Will it work??

Make sure your .profile have the following. DSHOME=/opt/Ascential/DataStage/DSEngine; export DSHOME PATH=$PATH:$APT_ORCHHOME/bin:$DSHOME/bin:$DSHOME/lib; export PATH . $DSHOME/dsenv LIBPATH=$APT_ORCHHOME/lib:$LIBPATH; export LIBPATH If not, add it. Exit. Open a new session, and try. Hi kumar, I hav...

Hi, I have to do read the Row count in Datasets and also delete the dataset from PX. For that i have created the script !#/bin/ksh set -vx cd /home/apps/GES/GESDev/seqfiles/workfiles/mh DSHOME=/opt/Ascential/DataStage/DSEngine . $DSHOME/dsenv DSBIN=$DSHOME/bin export APT_CONFIG_FILE=/opt/Ascential/D...

Is it for HP-UX or AIX? It is on AIX.After changing LD_LIBRARY_PATH to LIBPATH it is giving error "Could not load program orchadmin: Dependent module /home/apps/db2c/ddb2018/sqllib/lib/librwtool.a(librwtoo l.o) could not be loaded. Member librwtool.o is not found in archive" And also i co...

As you've noted, the .ds file doesn't contain the data, so removing it iwll leave orphaned datafiles. You should use the UNIX command orchadmin rm {dataset.ds} to remove bo ... Hi Arndw, I have also tried same thing. first i have done the settings :- DSHOME=/opt/Ascential/DataStage/DSEngine . $DSHO...

As you've noted, the .ds file doesn't contain the data, so removing it iwll leave orphaned datafiles. You should use the UNIX command orchadmin rm {dataset.ds} to remove bo ... Hi Arndw, I have also tried same thing. first i have done the settings :- DSHOME=/opt/Ascential/DataStage/DSEngine . $DSHO...

Hi Diya,

You cannot have output like this.For that you need another root tag above your <ApplicationPrincipalAttributeValues> and use aggregate mode in setting . Then you can get this result.

Hi,

Can you try by collecting DBMS WRITEERROR records.That may also be the reason for slow performance as records may be getting rejected or some problems in writing the records.

Hi,

Is this table is accessible while you import table definition through import table definitions through plugin.If it is not accessible then it may not have entry in tnsnames.ora file , put the tnsentry in that file.