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
Search found 39 matches
- Mon Aug 08, 2011 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reverse pivot
- Replies: 2
- Views: 2213
- Mon Aug 08, 2011 8:21 pm
- Forum: General
- Topic: how to rename multiple jobs
- Replies: 4
- Views: 3748
how to rename multiple jobs
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
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
- Tue Jun 28, 2011 12:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to reslove below error
- Replies: 2
- Views: 3129
How to reslove below error
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 ...
- Tue Jun 14, 2011 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I see the nodes in my project
- Replies: 3
- Views: 2633
Re: How can I see the nodes in my project
In the configuration file you can list of available nodes
tools-->configurations-->expand configurations
here you can see how many nodes available
tools-->configurations-->expand configurations
here you can see how many nodes available
- Mon Jun 13, 2011 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find the file name details used in a stage
- Replies: 4
- Views: 2745
Re: Find the file name details used in a stage
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
then follow the below path
properties--->options-->filenamecolumn
in filename columngive your additional column name
- Thu Jun 09, 2011 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Identify dead job threads
- Replies: 4
- Views: 2615
Re: How to Identify dead job threads
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
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
- Thu Jun 09, 2011 5:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic Required
- Replies: 9
- Views: 9560
Re: Logic Required
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
take aggregator stage and group the column, then take filter write filter condition as group by col=1-----------------------target1
group by col>1-------------------------------------target2
- Sun May 22, 2011 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to Delete duplicated records
- Replies: 7
- Views: 4262
Re: Need to Delete duplicated records
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...
- Wed Apr 27, 2011 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fatal Error
- Replies: 3
- Views: 4701
fatal Error
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...
- Thu Apr 07, 2011 11:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Exporting in datastage 8.0.1
- Replies: 2
- Views: 2698
Exporting in datastage 8.0.1
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
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
- Fri Apr 01, 2011 8:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Nth record import is failed due to delimeter missing in file
- Replies: 1
- Views: 1922
Nth record import is failed due to delimeter missing in file
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...
- Tue Nov 23, 2010 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to read BODY data by using sequential file
- Replies: 3
- Views: 2173
how to read BODY data by using sequential file
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...
- Mon Sep 27, 2010 12:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: is there any relation b/w configuration file and dataset
- Replies: 1
- Views: 1441
is there any relation b/w configuration file and dataset
is there any relation b/w configuration file and dataset
or
configuration file and sequential file
or
configuration file and sequential file
- Mon Sep 27, 2010 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is the use of parameter set in 8.0 version
- Replies: 2
- Views: 1719
what is the use of parameter set in 8.0 version
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
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
- Mon Sep 27, 2010 11:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: is it possible to view data set with help of Cat unix comman
- Replies: 3
- Views: 2280
is it possible to view data set with help of Cat unix comman
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
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