DSXchange

Hello,

How to run a Datastage job using "ROUTINE".. Can any one help me


Thanks

Hello, My job source is sequential file it contain column QTY as integer datatype and len 10. QTY test data like that 101 102 -10 50 100 -10000149 -1 My doubt regarding how to remove that "-" sign in the target file.i am using transferstage in the middle of source and target Thanks

Hi All, Thanks for your advise... Also do not assume that if you get the certification, you will get a job. There are folks like me asking hard questions that the certification tests do not test on. That being said, there are three tests, one for DataStage, QualityStage, and Information Analyzer. Go...

Hi All,

I want write certification in DWH..any one tell me about that certification details and also any sites are available regarding that certification...Any one can reply for that one plse


Thanks

Hi,

I solved my problem

ray.wurlod wrote:Yes, please do. Your job design without them is gobbledegook, as you can see. ...

Hi All, I have one about job design... My job design is as follows. Database1 | Dataset__>Transformer__>Lookup__>Database2 | | S.File1 S.File2 In Transformer i handling the error records these are stored in S.File1and Datbase1 used as lookup purpose... Database2 used as target pupose. S.File2 as use...

Hi,
I tried string to date and also date to string...
my source contain like that.12/02/1990 0.00009
i want to in target like that.12/02/1990


Thanks

chulett wrote:What is your small doubt? Have you tried using... StringToDate()? ...

Hi All,


I have small doubt regarding date converstion... i want to convert string to date in transformer stage..Can any help this one...

Thanks

Hi, My self create the source file thats why those warnings coming...Now i solved...Thank you Hi, First in which format the data is in? Like , if the data file is in unix , open and see it. Then set the format properties of the sequential file in data stage. And try to view the data. As per your pos...

Hi Naga,

yes thats wrong in lenghts...now i corrected all those...

Thank you very much

Nagasudheerkumar wrote:May be you have given the lengths as wrong for example u have 18 width length but you are giving only 4 length character . check the lengths

Hi Mayur, yes,in Seq.feile also i am unable to see meta data...then the following error displaying... Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter Check metadata and Final delimiter property of your seq...

Hi Mayur, yes,in Seq.feile also i am unable to see meta data...then the following error displaying... Imported only 4 out of 18 external characters into a ustring of fixed length4. Ignorning last 14 characters of externalustring up to delimiter Check metadata and Final delimiter property of your seq...

Hi all, My job source is sequential file and target is Dataset. Seq.file->Dataset..i want get all data from seq.file to Dataset.. then following warning i am getting. Field"SEQUENCE"has import error and no default value;data;{'EXTR_OUT_NEEDS',22/11/2007},at offset 110 here (SEQUENCE is col...

For starters, delete the duplicate post before anyone responds to it. How are you initially populating the lookup table? What is "ar lookup"? Can you load a local structure, such as a Lookup ... Hi, "ar look up" wrong only "look up"... my doubt regarding transformer st...

Hi all, In my job i am using look up table has column names location where location contains two values like store and wh.. We have to check that look up table inorder to get the data w.r.to these locations store and wh.. We have to check for a condition whether location belongs store or wh.store an...