DSXchange

All,

I have a file with header, detail & footer.

Detail record is stored in a different file along with row_num. I want to get the min(row_num) and max(row_num) from the file without using aggregator stage. is it possible?

Thanks
Karthik M

All, I have a file with below format. Header --> *H* Detail Trailer --> *T* File should have, *H* <Country Name ....> <Country Name ....> *T* I want to capture where Header <> *H* and Trailer <> *T*. The tricky thing is, I don't know what will come apart from *H* and *T*. If I write like <> *H* , It...

This issue has been resolved for now by changing euro symbol to "Euro" text.

do you mean using some kind of IF-THEN-ELSE structure instead of the TRIM at the end?

yes

I have handled in this way... Trim(header_valid_flagsv : '|' : trailer_valid_flagsv :'|':header_count_flagsv,'|','R') I have created stage variables and assigned values if header_valid_flag <> 'Y' then header_valid_flag else '' so... when it comes to transformer, either the reject reason or ''will c...

nope..we can change it to resolved

not yet expired :) I do understand his solution. But it is at high level. Series of IF statement in Stage variable ? Which function ? 6 stage Variables... first with error message or 'Y' If the first one is <> 'Y' then StageVar1 : '||' : stagevar2 else stagevar2 something like this I have to generat...

Ok. I Will try and get back to you.

But the same is displaying as '?' in datastage. When it loaded into Teradata through datastage it is showing some junk character.

where is the issue? It is really tricky for me to identify.

Mainframe? or Unix? or Datastage ? or Database ?

I usually search here before posting any questions. I missed to do that for this question.

All,

I would like to know the order of execution of stage variables.

Say for example, StageVar1, StageVar2, StageVar3...

Does datastage apply top down or bottom up approach while applying & accessing the values to the stage variables ?

Inputs are welcome!

I'm sorry for providing lack of info.

I am not still clear on your solution. Can you clarify ?

All, I have to load zero byte file into the table whereas the filename and reason as "File is Empty" needs to be loaded into the table. My Job design is something below SeqFile --> Transformer --> TeraData Connector If the Input file is zero byte none of the record will be uploaded into th...

It is not part of input, I generate all the reject reasons from the input columns by using stage variables and column comparison and store it in seperate columns. Header_Valid_Flag Footer_Valid_Flag Header_Count_Flag Footer_Count_Flag File_Valid_Flag RecordCnt_Match_Flag The columns will contain eit...

All, I have designed a job to capture the reject reason. Say for example, if the file is rejected because of "Header - Batch No is not correct" & "Footer Date format is incorrect". I have to store it something like below Header - Batch No is not correct || Footer Date format ...

All, I think there is some limitation to do comparison as below in the transformer stage column derivation. seqfile ----------> transformer -----------> seqfile DSLink1 DSLink2 In transformer stage, If DSLink1.DTLRowCont = DSLink1.TRLRowCnt then 'FOOTER RECORD COUNT IS MATCHING WITH DETAIL SECTION' ...