DSXchange

ray.wurlod wrote:I would expect to see all these rows in the reject file. You have declared three fields (999., XXX. and XXX.) but the "good" data have more fields than three. ...

Oh.. Very sorry... The original structure was 999,XXX,XXX and XXX.

Hi, My source files are complex flat files from V series Mainframe systems which send files in EBCDIC fixed length format. I collect rejects (using the save reject mode property) from these source files into another sequential file (just being curious). Now what type of rejects should I expect to ge...

I am trying to map a decimal column into a complex flat file, however i notice that the layout of the file shows the column being stored in packed decimal format with storage length less than the actual length of the column. Is it possible to write a decimal column into a complex flat file, without ...

I always had my doubts about using the row generators in my production jobs .... now that my fears have been alleviated, I feel much more free and ready to design jobs in a much better fashion!!

Thanks again.... :D

chulett wrote:

vrishabhsagar wrote:Shouldn't row gen be used only for development/debugging purposes?

No.

Hmmm.... Can someone tell me why? Won't the row gen decrease the performance of the job?

Hi All, While browsing parallel extender forums , I came across many threads which advise the use of Row generators in situations where we have to count rows and propagate count as 0 (out of a transformer) even if there are zero rows in the input dataset. This makes me wonder, if row generator can b...

Hi,

I am getting the following warning when using Teradata Stages in my job.

Teradata_Step2,7: Insufficient blocks for partition 7. Reading suppressed.

The result set however is not affected at all. Does anybody have an idea about this strange warning?

Thanks!!

Okay now I tried this instead, I put a reject link in the lookup and collected rejects in another table. Now I notice that all those rows which do not match the lookup go through the reject link, however for those rows where lookup is success, they are not getting translated, ie. it is populating ID...

Hi, I have a requirement that I state as follows: There are two cols in source table : ID1 and DATA There is a reference table having the following cols : ID1 and ID2. I have to translate ID1 to ID2 in the source file, IF a coresponding match exists in the reference table between ID1 and ID2. If the...

Hi All, I have two datasets (basically same file), I sort them (set to be hash partitioned on key cols), and then pass them into a Change Data Capture stage. In CDC i mark 2 cols, out of three as key cols, and collect the ouput into another dataset. When I observe in Director logs, however I see a w...

I got a job which prompts for the day of run... If no value is passed it should take the previous month's date... how to get that?? For any such activities, I usually employ scripts and use command stage at sequencer level to implement the logic. Your scripts can return values to the jobs as parame...

Hi, In my source there are 3 condition for three values.If name=a then 1,name=b then 2,name=c then 3. For any other value will not be considered. Now in tranformer when I am using if then esle the problem is that in the last loop of else I am not able to give any other value as no default value is ...

Hi All, Please let me know how through Datastage job (parallel) we can remove the header and trailor in sequential file. If the header and trailor has same no of field as the records and also the delimiter is same as the record. Is it done through HEAD /TAIL stage.... Please resolve my query. Thank...

Hi All, Thanks for responding... Right now I have used this to fix the problem, Str("0",3-len(trim(DecimalToString(DSLink3.FLQ66B080_TOACDE1,"suppress_zero")))):DecimalToString(DSLink3.FLQ66B080_TOACDE1,"suppress_zero") Since I am running out of time, I am unable to tes...

Hi All, I have a source file col that has decimal data in form 020, but when I convert it into varchar format using DecimalToString(colname), then it is automatically converted to something like 20. I would like output in form 020 (varchar data). Can anyone pls help. Thanks in anticipation. Rishabh