DSXchange

Hi, I am also trying to learning about DataStage Commands like UVSH, TST_GGS, LOGTO,..etc. And also unable to find documentation for the DataStage Job tables like DS_JOBS, DS_OBJECTS,.. etc. Didn't find any documentation related to this in DS Ver 7.5 & 8.0.1 So, Please help me, where can i find ...

Hi, I am also trying to learning about DataStage Commands like UVSH, TST_GGS, LOGTO,..etc. And also unable to find documentation for the DataStage Job tables like DS_JOBS, DS_OBJECTS,.. etc. Didn't find any documentation related to this in DS Ver 7.5 & 8.0.1 So, Please help me, where can i find ...

No .

I would like to now about admin settings in datastage thru command line and where the datastage jobs are stored internal with their metadata.

Thanks!
venkat

I wants to implement first() function in datastage. As you know we have first function in aggre trfm stage in informatica . In my case we are getting the values from source seq. file, and it is a migration from informatica to datastage. So, we need to replace same logic in PX job. Please tell me how...

hi all


where can i find banking data warehouse model of ibm using datastage.

any one please tell me


thnks
venkat

Hi,

What is the difference b/w normal lookup and sparse lookups based on physical memory?

any material available internal process pls tell me

thnks
venkat

Hi all, I have sample question about banking data warehouse. One customer came to the bank for one day Example: 11:00 am x customer opens an a/c in bank 1:00 pm same x customer deposit some amount to his a/c. 4:00 pm same x customer withdrawn some amount from the bank. 7:00 pm again same x customer ...

HI

i need a help for below problem.


seq file1 -> seq. file2

seq. fil1 contains 1, 2,3....10 record example.

i need target seq file having 100 records.

like 1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,....,3. like wise.

any one please tell me how to do this.

thnks
venkat

hi,


please tell me where can i get exam materials for px 7.5x2 exam.


thnks
venkatesh

hi

anyone please help me.

how to identify actual left outer join happend in join stage.


thnks
venkatesh

hi

any one pls tell me how to use restructure stages like make sub records, split sub records, combine records, promote sub records, make vector, and split vector in datstage 7.5x2...

what is the difference in each one.




thnks
venkat

hi

i am reading data from oracle like this

empno1 sal

1 10000
1 10000
1 10000
1 12000
here 4 sal are the months of jan.,feb., mar., apr...

output like this report

empno jan feb mar apr may


so, pls help me how get this output using in datastage.
thnks
venkat

hi i am reading data from oracle table emp: the data look like this... empno deptno sal 1 10 1000 1 20 2500 1 10 3000 2 10 2500 2 30 500 2 20 2100 i want report like this maxsal empno deptno no.of emp in dept pls tell me it can be write in sql query or using any stage in datastage. thnks venkat

Hi friends,


how to set settings of DSN for ODBC stage in Aix envir.




thnks
venkat

hi

any one pls help...

how to view the log file data like warning and fatal informaton in aix box. pls tell me which location log file and datastage job are stored in aix or unix env.



thnks

venkat