DSXchange

I need guidance on the following issue. I have a scenario like this. From an oracle table A I will 80 million records. I need to check several conditions. For example : select * from TableA where CODE NOT IN ('A','B','C'........'F') select * from TableA where CODE IN ('Z','X','Y') I want to implemen...

thanks :D

Well i am not in any shop, we have an issue to convert few server jobs to
parallel jobs.

Could any one suggest me, How to convert server job to parallel job?

Is there ant conversion tool?


Thanks in advance!!!

well in sequential file i use charchter set as EBCDIC.


Can any one telll me?

is it possible to use ascii funtion in transformer?

if i can use like dis ascii(s_code) i can get result ?

Hi guys, my mapping looks like seq===>txn====>oracle 1) well my data is in EBCDIC format. There is one field called s_code its data type is char(1). When i load in to target , i am getting  (this format in the field). 2) so in sql developer i wrote a query select ascii(s_code) from orc_stg. I got v...

Hi GUys , I have problem in reading FIXED WIDTH file. The file format is EBCDIC(character set). Fox example: input file: ab1234crest89.12 usually get the copy book name PIC x(2) ID PIC x(4) class PIC x(5) price PIC s9(1)v(2) comp-3 so while defining metadata in sequential file: name char(2) id char(...

hey @thanks all


i am just new to this tool.

can you please more specific?

Hi Every one,


How many types of parallel jobs are there in datastage?

I know there different types of jobs are there in datastage like server job, parallel job, mainfraimes job/


thsnks in advance.

@ray.wurlod,I am extremely sorry.

its not a interview questions. When i am interact with my friends, they asked me these questions. I tried in google search and IBM datastage documentation. I coun'dt find SUITABLE answer for these kind of questions?

Please kindly guide me in learning concepts.

1.When do u think, one should use ODBC stage for reference over hash file?
2.When is hash file not efficient?


thanks in advance