DSXchange

I have a sequential file,coming in with 10 columns,the 5,6,7,8 and 10 columns are date fields.All the columns 5,6,7,8 have date fields in the format of mm/dd/yyyy.But column 10 has date field coming as Nov 30 200 Jan 01 175 So,Now i want to validate column 10 saying if date is not coming in as 'mm/d...

Yes, I want to declare 'Invalid' for this type of date formates. I'm guessing your issue is the fact that you would want your three example dates to be declared 'invalid' - the problem is they are perfectly valid dates. Seems like you'd need to do any standard date checks you currently are doing and...

Is there any method for checking the date format (particularly year) in datastage? I am getting some dates in source before I load into target I need to check is that date is correct format? for ex: I am getting some dates like below: Nov 30 200 Jan 1 175 Dec 21 200 Year is not coming properly. I've...

We have scripts that disable & enable constraints, dropping and recreating the indexs, trucating the tables etc... before a particular job is running. Now we want to replace entire scripts in the job sequencer with out using these scripts. Is it the right apporach or not? Callling a script is th...

I am comparing seq file data with table data. 3 keys combination is used as primary key.

But some of my record's key column values are null. Pls suggest me, how to compare null values?

"THANKS A LOT" It would work. quote="chulett"]Would have been nice to have sample data that matched reality a little better. :? You can still sort, yes. Just to beat this horsey a little longer... Assign a record number to each row in a transformer, @INROWNUM will work nicely. T...

Thanks for quick reply ....but my issue is still ther ... Actually my data looks like this.... Member_key Id_key 1234 75 1234 abc 1234 %Agh 1234 =AVX here order by is not useful...right.... So, from your eample: Member_key Id_key 1234 23 1234 24 1234 25 You would like the Id_key of 23 to be stored f...

Thanks for your reply...but how would we do 'reverse sort' on a single key. Ex:Member_key Id_key 1234 23 1234 24 1234 25 When we store this data into a Hashed file it will keep the last record but I want the first record. I used order by while extracting the data from table but it's not changing the...

Thanks for your quick reply, but sorting is not possible because I have only 2 columns in hash file (member_key,sese_id) and member_key is key column.

chulett wrote:Reverse your sort order. Last one in wins, period - so if you want the 'first' one you need to make sure it arrives last.

Those are key columnes, if u don't make a link it will give compilation error right?

us1aslam1us wrote:Do not link the fields just write the constarint ...

Eff_str_dt and Eff_end_dt are keys in hash file, I made link these two columns with ctrl_dt so hash file trying to match eff_dts with cntrl_dt but my condition is different. How to write this code in hash file key expression? With Server Job, Pretty much as you have specified. In Constraints : in.ct...

Hi Folks,

How to specify this lookup condition in transformer;

Eff_str_dt<=ctrl_dt and Eff_end_dt>=ctrl_dt

Basically I am getting ctrl_dt as source and Eff_str_dt & Eff_end_dt in hash file.


Thanks,
Raj

Thanks for your responses. Ray i have a question which one is the best one In Single job with multiple Tranasformer stages or spliting the big job into multile jobs One job, but with multiple Transformer stages (say, not more than four lookups per Transformer stage) would also be OK. You can enable ...

dxp wrote:

rajkraj wrote:

dxp wrote:Hi raj,

whats the windows version...2000 or 20003?

Mine is windows xp prof

mine is 2003. I enountered same problem...but after going thru 'Manage Server' option, I am able to solve this problem.


dxp.

hi dxp,

could you please explan how you solved this problem in 2003.

track_star wrote:Have you been able to get any jobs to connect to Oracle and do anything?

yep, using ODBC, DYNAMIC RDBMS i am able to connect to oracle and my jobs running properly