DSXchange

The only way that 100 rows going into a transform won't generate 100 rows for each and every output link is if you use constraints (or have errors). So we need to know what constraints you have used. ... I set a stage variable like this: svInsNewRow:IF(IsNull(FIELD_NAME) or Len(Trim(FIELD_NAME))=0)...

hi.. can you run the job without constraint.and find out records poupulated in the target. do you have any message handler in your job... Like I say it before, ther is not warnig after runing the Job. And the director log say the Job hat the statut finished without the see log option. and one about...

The messages you posted are for a lookup stage, yet your are talking about a transform stage. Ignoring your lookup stage issues, the transform stage limits output only in the constraints, so please po ... Ok but I posted the message in this form to give you more information about the job. Now I can...

Hello any one, I have a Job that runing well according to the director log information. But curiously the target output file that match the constraint condition is not populate with data for the input file. I can't understant why is this so. I've two output file on the transformer. That mean only tw...

Hell any one, It seems to work too with the way I set the Null Condition(If (Isnull() then "yes" else "N"). But it doesn't populate any output file where the condition is match. I don't receive any warning more too. And the Job Status in Director finish without see log option. Th...

Could just be a simple syntax issue as well... verify that your parentheses are balanced. Mike I verify my parentheses. There are well balanced. Has you set it in a stage like that without problem? It look like there are 2 If and only one then. Is it so normal? IF condition1 Then seting1 Else IF co...

IF "FIELD_NAME" can have a null value, then the derivation should be IF IsNull(FIELD_NAME) THEN 'N' ELSE If(Len(Trim(FIELD_NAME))>0 Then "YES" else &quo ...[/quote] Hi ARNDW I try your proposition in the stage variable but this is not accept. I get a read derivation by setti...

I just noticed something from the first post. Stage Variables cannot be null, so you need to ensure that you work around that limitation with the null-handling functions (i.e. IsNull(), NullToValue() ... May be, I must tell you how I handel this. So, in the transformer stage I've setted a stage var...

Imperator Yollson, this means that you have a null value in a row in column "F" and that the column is not nullable. This is data driven and cannot be solved unless you make the column nullable - b ... After reading your reply, I'm asking myself if it is another way to make a field nullab...

Hi, I've trouble by runing my Job since a week. I've the following badly warning Message: APT_CombinedOperatorController(0),0:Field ' F' from input dataset'0'is NULL> record dropped. I'handell the specifie FIELD in the Transformer by setting a stage variable that deal with the content of the field. ...

Why not just generate new sequence numbers using one of many other methods? What business problem are you attempting to solve? Mike You are right. I'll try generating Sequence Number using The Key Generator-Stage. Thank's for your reply. I'm developping SCD-2 and SCD-1 Type in datastage. The SCD-St...

Use a Column Generator stage on each input to generate an artificial key that you can use to join in a Join stage. This should be the row number perhaps qualified by the node number if you are thinki ... Thank's for your response. Please can you tell me how does it look like? I mean the Column Gene...

Hi all, I'm dealing with Sequence File in parallel job. Instead of using File -->Propertie-->format-->Field tab, I've adressed the null Field length Problem in my sequence File by setting a Stage Variable for all possible Null FIELD like this: If Leng(Trim(Input_coloumn))=0 then "<EMPTY>" ...

I' 've done it;
Thanks