DSXchange

Hi all,.

thanks T42 for your reply.
my target database is sqlserver
i need to generate sysdate in the output in the form of

yyyy-mm-dd 00:00:00.000 . ( data type is timestamp in sqlserver)



i am not using Basic tarnsformer in paralle jobs. how can i approach for this problem.

Hi all, my source is sequential file stage, when i want view the data using sequntial file stage data browser, it is giving folloing error, cal anyone let me know #I TUTL 000031 12:52:04(001) <main_program> The open files limit is 100; raising to 4096. ##I TOSH 000002 12:52:05(000) <main_program> or...

Thanks T42;

I got it how to use stage variable.

anyway thanks for ur suggestions.

hi all, i need to generate surriagte key nsar_id (sequence number). i am using surrogate key generator . but it is giving this error Surrogate_Key_Generator_12: Error when checking operator: When binding output schema variable "rec": When binding output interface field "created_dtm&qu...

Hello rich,

i don't know how to use stage variables. can u please let me know how to use stage variables for my problem.

Hi all; i need to caliculate change_in_total_net_assets based on same fund name and previous years filing date eaxmple; Source field 1 field2 field3 (fundname) (totanetassets) (date) wade fund inc 667 12/31/2002 the internet fund 14500 12/31/2004 wade fund inc 631 6/30/2003 target; field1 field2 fie...

thanks ray, t42; but can u explain little more about how to develop job; the relation between table 1 and table 4 is one ------many the relation betwwen table 1 and table5 is one-----many the relation between table 2 and table4 is one-----many the relation between table3 and table 5 is one----many; ...

thank you

martin

Hi all, i have source input 47 fileds (tab sepearetd), those should be loaded into 5 tables. 8 fields are mapped to table1. 21 fields from source should be eneterd as 21 records in table2, remaining 18 fields from source should be entered as 18 records in table3. (table2 and table3 are manually load...

Hi thanks to Kim, Sainath; i am adding one more doubt to the my previous question, i am loading 2 tables manually pri_asset_type (21 records), investment_risk (18 records), above 2 tables are loaded from source table conveting fileds in to rows , is it possible to use pri_asset-type , investment_ris...

thanks ray.

Hello shantanu,

thanks for ur help,

can u give one example how will u connect datastage job with autosys

i am new to datastage. we are working on datastage enetrprise edition. as far as i know extract flatfiles we use sequentcial file in server jobs.what about in parallele jobs.

i am new to ascential software. i came to know that both are data quality analysis tools.

i am new to datastagem

what is file manipulation, how does we impleme this using unix shell programming.