DSXchange

Hi Ray,

As a Normal user ,i can't view your whole premium posted content.
Is it possible for you to help me out again by posting it as normal user content.

Thanks!!!

Hi All, I am planning for Datastage Certification,and over the IBM site i comes to know about the two certification 000-418 (IBM Certified Solution Developer - InfoSphere DataStage v8.0) and 000-419 (IBM Certified Solution Developer - InfoSphere QualityStage v8.0). Here I wants to know about that ca...

Hi,

I am new to this tool. By means of command activity I don't know where to use this count and how to use this,So Please clear me this command activity in detail or if possible provide with the another solution.

Thanks,
Vishal J.

Hi All, I have two jobs say Job1 and Job2,and I want to Execute these jobs conditionally depending upon the rowcount of a table(Table1), which is stored separately in database and not used in either of Job1 and Job2. For Example: If my Table1 contains zero records i.e. rowcount=0 ,then i want to exe...

Hi Craig, By using to_char() function,it is working fine . But i didn't find any proper conversion code in Incov() function to convert these two values in same format. I want to use the Datastage provided function to perform this task,because i feel by using Oracle supported function and using them ...

Hi All, I want to perform the join operation on two columns of Oracle. First column is having datatype Date and contain values in format : 7/10/2003 10:37:00 AM Second column is having datatype Timestamp(6) and contain value in format : 7/10/2003 12:00:00.000000 AM when i am comparing the values fro...

Okay,just let me know how to pass multiple rows to a reference link if my reference input is hashed file.

Hi Chulett, yes,all my dimension tables returns more than one record ,as i have used all the hashed files in my job as input . My Primary table is Asset and for example consider two lookups (locatoin and site) each lookup table contain surrogate key value,my target table is Fact_Asset and this fact ...

Hi,

I have now loaded all the dimensional table data to hashed files ,but i couldn't able to retrieve those data on another job,please help me how i can retrieve those files on another job?

Is it possible to have the hashed files without key columns?

Hi chulett ,
I know that hashed files provides fast access to data but as i am not using any key columns for data retrieving ,so may i know how to process the hashed files in my job to replace with the ODBC stage.

Following is my job design for all of reference purpose:

Hi, To discuss about my job in detail. my source and target is remote oracle server,and i am passing the record to output fact table which is table rh_fact_asset ,primary table is asset (contain records 10000) and other 17 dimension table each one containing about average of 1000 records for lookup ...

Hi All, I am designing a fact table ,which contains 17 dimension tables.To lookup into these 17 tables(reference tables) and retriving data based on certain condition ,but the job execution is taking more time to execute the large number of records,so please let me know how i can improve the the tim...

Hi All, I have a source table and target table ,i want to transfer some records into target based on records exist in target table i.e. if target table is empty then i want to transfer all the records from source and if target table is not empty , i want to transfer the records from source which are...

Hi All, I have some problem during use of Map Designer. For Ex: I have dimension tables called Employee(Empid,Empname) and Department(DeptID,DeptName) in datawarehouse, one source table which contain columns from Employee and Department as well as additional of it's own.I have target table which is ...