DSXchange

Hi,

Hey i don't understand how the data stage causing this i having 12 projects of 110 to 223 MB each and we are connecting to the client portal in UK from India and access the datastage from here through CITRIX. We take daily backups of all projects through CITRIX. But we never faced any problem.

Hi, I also had the same scenario where i need to concatenate all input fields to a single output fields and input has 325 columns. Try to have two stage variables where in one have one you concat one and in other concat another. then you compare these two stage variables If you still get the problem...

this is the job[/url]

Try This: JanOnlyHashedFile | | | |[RefLink] | Jan&FebSrcFile--------> Transformer------------------------------------>Output1 | |[Only Feb Constraint: IsNull(<RefLink>.<AnyColumn>)] |-------------------------------------------->Output2 Output 1 Will have All Account Numbers. Output 2 will have...

Try This: JanOnlyHashedFile | | | |[RefLink] | Jan&FebSrcFile--------> Transformer------------------------------------>Output1 | |[Only Feb Constraint: IsNull(<RefLink>.<AnyColumn>)] |-------------------------------------------->Output2 Output 1 Will have All Account Numbers. Output 2 will have...

Then you would need to change your design of job from Hashed File | | | V Src----->TX----->TGT To Src | | | V Hashed File----->TX----->TGT | | | V Reject Link Hope this helps. Hi, I changed my design to this, but don't know why, the records going in lookup file are 151 but comming out of it are 550...

It sounds like you need to change your lookup hashed file into the main input stream and your current data stream into the reference stream to get the intersection and thus the complement of your two sets. Your current design will, as you've already noted, only get you the reference rows that match...

Hi, I am having a lookup for accounts having any kind of transaction for a particular month. i.e. the key field is account number. Now the lookup hash file is having some extra records other then the matching account numbers of lookup. I want to extract those extra records in another file. I tried t...

Hi, if i want to run the mapping in dec 05 then source will have amounts from jan 05 to dec 05. Since your input file have the cummulative ammounts, is it you want to find the difference only for current month and previous month or current month and sum of all previous month? What is your cardinali...

Hi all, I have to develop a mapping in which i have to generate a trial balance target file. The source file is a flat file in which i'll be having an amount field which will be having amounts of all the months before a particular period. for e.g. if today is feb end date then source file will have...

Hi, Y=Field(Oconv(D1, "D-YMD[4,2,2]"),'-',1)-Field(Oconv(D2, "D-YMD[4,2,2]"),'-',1) Mon=Field(Oconv(D1, "D-YMD[4,2,2]"),'-',2)-Field(Oconv(D2, "D-YMD[4,2,2]"),'-',2) If Substrings(Mon,1,1)='-' Then M=12-Field(Mon,'-',2) End If Substrings(Mon,1,1)<>'-' Then M=...

Hi I have a input string. ABC-1 DEF-2 etc. I have to insert 3 letter code in middle like ABC-OPR-1 DEF-NOP-2. which function i have to use. THKS Hi, You can simply write a routine in which you can find the exact place of "-" and replace it with desired value. The function you can use is I...

Hi All, I have to find out the day of the week for a particular schedule date. Now the problem is, the OCONV(Date(),'DW') function works fine when system date is given as an input because the Date() function returns an internal number. But i am having the schedule date comming from a source file. I...

I have a very fundamental question regarding routines. Can somebody please tell me where we can write routines in datastage. I would appreciate if somebody could give me a example of a simple routine and where to write it in DS. Please dont ignore it as a very basic/fundamental question. Can i pass...

Hi This is sateesh.. actually in my project i want to find all of jobnames and start date of that job ..and this information i want to load in sequential file..can u please give me ur sugestions.. regards sateesh... Hi Sateesh, If you want the job name during its runable state. then you can try wri...