DSXchange

problem solved.. .netrc is defined in my home directory and when the ftp runs the unix settins sets the home as / and not home directory so it goes and check for the .netrc file at / instead of checking at home directory . Hence it is not able to pick up userid/password of mainframe server from the ...

NO. There is no hard and fast rule that a primary Key should be defined in Staging Table

HI I am running a before job subroutine perl script to FTP and get file from mainframe . I have also put an entry of the user id and password in the .netrc file so that the when the FTP to mainframe is done it doesn't ask for user id/password . I ran and tested the script manually by running the scr...

Sorry to say that i don't have any reference for Merge Stage

I pretty much got what I want but wanted to know if there is a way I can negate the redundancy of extra column in the Merge Stage itself or this is the only way how DS works.

Merge issue My requirement is . 1. File1 and File2 2. ID is key field in both File1(ID,Name) and File 2(ID,Designation) 3. Join File1 and File2 base on the ID field 4. Get File3 with this column(ID,Name,Designation) with ID as key field I have followed this MergeStage------->Output seqfile 1. First ...

The date field which i want to pass as a run time parameter will be use in the User defined query in ODBC stage where i query redbrick database something like this Select c1, c2, .. from Table 1 where Laod_datetime > #param# The above #Param# is the value i get from Oracle database and want to use w...

Why don't you just use a stage variable with INROWNUM to get the count

HI, I am having a scenario like this. 1. Query Oracle Table to get A Date field and keep it as a parameter 2. Use the above parameter in a Where clause when I query Redbrick Tables to get the required columns As the two table reside in difffernt schemas one in Oracle and anothere in Redbrick I canno...

What is your reporting tool . I think it is more of a reporting requirement. OLAP tool like MicroStrategy, BO will handle that very easily or write custom sql in DS stages to get it

MQ Series... Get the Xml format through MQ and run a 24*7 job to keep on getting the Xml input and write to a file. You can have Daily unload files which you can sum up over the weekend and process it for insertion/update or as your frequency demands.

If you call the java code before or after the DS job then use a shell script to call the java code and define it as Before or After job subroutine

I am confused.. I have 3 plug ins 1. ORAOCI9 2. ORAOCIBL 3. ORABULK This is what i tried out and people suggested 1.From previous discussion i got that ORABULK is not supported for oracle 9i. 2.But while trying to use ORAOCIBL i was suggested that this stage will not work if DS and oracle reside in ...

My Database(redbrick) reside in - M1 server Datastage reside in - M2 server Oracle reside in - M3 server #1Now i want to run DS job in M2 collect data from M1 and load it into Oracle residing in M3. Is it possible to do it using ORAOCIBL STAGE in automatic mode. If not what are the options #2Imagine...

What is the meaning of that automatic. Does it mean i have to just specify the target table and don't have to create Ctrtl file and data file to load it .