Search found 66 matches

by dssiddu
Mon Nov 03, 2008 6:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Dates
Replies: 5
Views: 1614

Generate Dates

Hi All

I want to generate all the dates between 2 given years. Like 2008 to 2020.

i mean 01-01-2008 to 31-12-2020.

Could you please guide me how to do that in DS.. ?

Adv Thanks a Ton
by dssiddu
Thu Oct 02, 2008 4:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String To TIme
Replies: 2
Views: 1504

Hi RAY

Thanks a lot For your info.
by dssiddu
Thu Oct 02, 2008 3:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String To TIme
Replies: 2
Views: 1504

String To TIme

Hi All My Src Field Varchar(6) I/p like this 120000 I want to convert to 12:00:00 of time data type. Modify does that but i dont want to use that . Done with StringtoTime function no use and also Col[1,2]:Col[3,2]:Col[5,2] also no use basicaly getting ******** values . Please shout your solutions Ad...
by dssiddu
Wed Aug 08, 2007 3:07 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Table Taking much Time
Replies: 4
Views: 3560

hi ray

thank you so much for your info........
by dssiddu
Tue Aug 07, 2007 6:16 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Table Taking much Time
Replies: 4
Views: 3560

Thanks a lot Ray

But my question is if one database contains more than 100 tables then each table has to compare with 99 tables am i currect so many column pairs . Could you please tell me approximate time to run this for 2000 rows sample data ??

:roll:
by dssiddu
Tue Aug 07, 2007 4:16 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Table Taking much Time
Replies: 4
Views: 3560

Cross Table Taking much Time

Hi all

Cross Table analysis Taking much Time to complete ?
Could you please tell me can we do it faster ?

Adv thanks
:roll:
by dssiddu
Tue Jul 31, 2007 2:48 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Table Analysis
Replies: 0
Views: 1914

Table Analysis

Hi ray Please i have 1 more clarification: While doing table analysis the analyser will select some primary keys from the table depending on the compusitemaxkey.So my question is by default its 2, then analyser will select 2 or more keys eventhough more than 3 keys . what will do we have to select a...
by dssiddu
Tue Jul 31, 2007 2:42 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: The requested Data Is Empty
Replies: 5
Views: 3809

Hi Ray

Could you please elobarate it, Bcz i am not clear still.....
by dssiddu
Mon Jul 30, 2007 7:52 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: The requested Data Is Empty
Replies: 5
Views: 3809

Hi Ray

For your info . Sample row count =Zero for that perticular table.
by dssiddu
Mon Jul 30, 2007 7:42 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: The requested Data Is Empty
Replies: 5
Views: 3809

Hi Ray thanks a lot for your quick replay . Still that sample data not prepared , for that table when i am going to click on "view smaple" at that time i will get this error. Q) please tell me while importing table from the database to repository only table strucutres imported or even actu...
by dssiddu
Mon Jul 30, 2007 4:42 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: The requested Data Is Empty
Replies: 5
Views: 3809

The requested Data Is Empty

Hello All

After column analysis done , for some tables i am geting the error like this "The requested Data Is Empty:" when i am going to view the sample data even though data is exists in the oracle db .

Could you please send how to resolve it .....

Adv Thanks
:roll:
by dssiddu
Thu Jul 26, 2007 12:37 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Data Sample creation in process please try later
Replies: 2
Views: 3029

hi Ray Wurlod

hi

thanks a lot, but that will take much time, even though when that process finished in the unix server , me getting the same error.
by dssiddu
Wed Jul 25, 2007 9:51 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Data Sample creation in process please try later
Replies: 2
Views: 3029

Data Sample creation in process please try later

Hello all

Could you please guide me , how to over come this problem
"Data Sample creation in process please try later" me geting this when I am going to view the sample data after column analysis done for some tables .

adv thanks a lot
by dssiddu
Fri Jul 20, 2007 6:25 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Unable to select rows from the table
Replies: 2
Views: 3032

Unable to select rows from the table

Hi all

please guide me ..?

Unable to select rows from the table in profile stage while doing column analysis????

by dssiddu
Tue Dec 05, 2006 11:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to capture job log into text file
Replies: 10
Views: 8732

Print to file

From The Director Client tool ,There print option from this u can directly print to file(.txt)