DSXchange

Hi,
how to do reverse pivot

source:
EID,1stname,Middlename.Lastname
101,sunil,kumar,sharma
102,web,sphere,datastage

my output will be like this:

EID,Name
101,sunil
102,web
101,kumar
102,sphere
101,sharma
102,datastage

please how to this one

Hi,

how to rename multile job names.

i know by right click on job in reposatory we can rename
if i want rename some 100 jobs how to this one

XFM_MED: Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [**********] used for date_from_days_since type conversion. can plz how reslove ...

In the configuration file you can list of available nodes

tools-->configurations-->expand configurations

here you can see how many nodes available

in seq file create one additional column in column tab,
then follow the below path
properties--->options-->filenamecolumn

in filename columngive your additional column name

Hi,

if u r working on 8.0.1 version

login to information server then follow the below path

Administratation->session management->active sessions

based on locked job id select the exat one, then click on disconnect

Hi,

take aggregator stage and group the column, then take filter write filter condition as group by col=1-----------------------target1
group by col>1-------------------------------------target2

I think source will be like this: eid,date,name 23,2011-03-21,james 12,2011-04-10,mat 13,1982-03-03,Karth 23,2011-04-21,Maek 12,2011-04-23,Ojem 13,2011-05-13,Kim in this case: Seqfile---->Sort------->RemoveDup---->Dataset sort on Eid (descending) Remove duplicate on Eid, duplicate retain = last this...

Hi all, when i am running Job i am getting below Fatal error, how to reslove this one my target is teradata TRG_L0053_ADJUSTMENT_H: [IIS-CONN-TERA-005004] RDBMS code 3807: Object 'DL0053_In_SDD_Adjustment_H' does not exist. SQL statement: DELETE FROM DL0053_In_SDD_Adjustment_H ALL (CC_TeraConnection...

i am Exporting jobs & seque's in datastage 8.0.1
here i am exporting dependent iteam's also

while exeporting i am getting on pop-up saying that
"9 readonly iteams where omitted"
how to know which iteams are omitted

Thank's
Ram

Hi, in production while running the job i am getting below fatal errors 1.consumed more than 100000 bytes looking for record delimeter; aborting (end delimeter is missed in Nth record) 2.Import error at record 1892716. actually we r reading data from 15k files, import is failed at 1892716(due to del...

HI, i have a file , this one look like this aaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbb cccccccccccccccccccccc col1,col2,col3 10,a,200 21,b,300 23,d,100 ddddddddddddddd eeeeeeeeeeee ffffffffffffffffffffffffffffffffffff kkkkkkkkk here i want to read valid records means (col1,col2,col3 10,a,200 21,b,300 23,d...

is there any relation b/w configuration file and dataset

or

configuration file and sequential file

in 7.5 version parameter set is not available,but

in 8.0 version i am using parameter set to parameter set to add which parameter r required to our job.

is there any another usage of parameter set

why mainly parameter set added in 8.0 version

hi,

is it possible to view data set with help of Cat unix comman

if not possible what message it will show

can anyone try this one in u r pc's