DSXchange

my input date format is dd/mm/yyyy and my target db is oracle and that conversion i did uing right.tag

I am using server edition,I have to populate in my target enddate column as "2045/11/08" i enddate column datatype is timestamp i am tried aboveformat and "2045/11/08 00:01:00" but it is showing only year "2045/00/00" how can i populate the whole thing

Hi skumar, Here are the some of the differances Here are some of the differences I could come up with: * Both Server and Px (parallel, Enterprise) might share the Ascential name but they evolved quite separately from each other, so it is not surprising that they handle certain things differently. * ...

I needed to generate sequnce number like

a-1
a-2
b-1
b-2

how can we do in datastage

Can any one answer to his queries? 1.How do v search data in HASH file? 2.If ENAME varchar2(40) from one source,ENAME char(100) from another source and the target is having NAME varchar2(50) then how does datastage handles this situation? and How datastage handles string and numbers datatype sources?

Hi all,

Please send me good documents on how to do jobs in Px becoz i need to get femeliar with this jobs.Dont ignore this message i am need of this documents hardly

Hi all,

Please help me in doing this it is very urgent

Hi All,

My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.

Regards,
RAGHU

please let me know how to remove duplicates while transfering source to target. i know that v have to use lookup stage but where to give condition . suppose it is in this format seqfile------------transformer------------target \ \ \ \ \ \ lkp stage rejects i mean where to do look up and how to use c...

i am not getting any error while doing itself in the preview i could not able to get columns in correct order

hi,

i could able to do process with fixed length records but not wit variable length please let me knw how to do it.

byeeee
vijaya

Hi All,

Please let me know where can i get lab exercises to practice on DataStage PX

Regards
vijaya

Hi all,
Please let me know how to count number of records in a source file.Reply me soon

Please let me know how to impement Type2 scd in PX .