DSXchange

Are you getting any warnings ? Can you send me your date format ,is it a date or time stamp field? My source Table for COL_DT Type = Date, Length = 10 and Nullable = Y. My Target Table for COL_DT is Type = Timestamp, Length = 23 Scale = 3, Nullable = Y. I am doing DateToString conversion. Yes I am ...

Try this If IsNull(Col1)= 1 then SetNull() Else Trim(Col1). Hello samsuf2002: Thanks for your quick response. I tried the following: If IsNull(Opportunity_Product_lkp.COL_DT) = 1 then SetNull() Else Trim(DateToString(Opportunity_Product_lkp.COL_DT,"%yyyy-%mm-%dd"):' 00:00:00.000') The job...

Hello: I am getting the same error. The Job Flow is as follows: DB2 | \|/ Lookup --------->Transformer -------->MSSQL Tbl /|\ | | Agg | | | Dataset(s) Dataset Verified: On the Metatable Table COL_DT is Type = Date, Length = 10 and Nullable = Y. My source Table for COL_DT Type = Date, Length = 10 and...

Not(IsNotNull(Input_Col)) = NOT(reflink.NOTFOUND)...?

In Server job the stream going to the hashed file will have constraint reflink.NOTFOUND and for the reject it will be NOT(reflink.NOTFOUND) . Is this correct...? In PX the constraint for reflink.NOTFOUND = IsNOTNULL(input_colName) and Reject link = IsNull(Input_Col_Name) Also, how do i interpret ser...

Hello Problem resolved:

I am geeting the same error but for a timestamp field. APT_CombinedOperatorController,1: Field 'UP_FOR_RENL_DT' from input dataset '0' is NULL. Record dropped. COL_DATE is set to Nullable COL_DATE is a Timestamp field. This col on source side is a date col and on the target its a Timestamp col. I co...

So initial lookup job do the following: Job1 DB2 Table ---> Transformer ----> Dataset_A Now to flip the key columns I do the following: Job2 Dataset_A --->Transform------>Dataset_B Some jobs use Dataset_A and some jobs use Dataset_B. However I am told I can use the Dataset_A with the copystage to fl...

Hello: In the job I do a lookup on the DB2 Dimension table and output it to a Dataset. This is a seperate job. So I pull the COL_KEY (PK) and COL_ID (FK) into the DataSet. QUESTION: Can I inverse the key column and use this Dataset for lookup.....? So I set the COL_ID to be my Primary key col and CO...

PX 7.5.x version.

What about a Integer Stage variable and setting it to null. How does one do it...?

I do not have a premium membership access.

Thanks.

Hello All: I have in my job properties - Parameters the following: EXTRACTSTARTDT String 19000101000000000 EXTRACTENDDT String 20060906123746890 Target Table (MSSQL) Target_column_Name Timestamp 23,3 (Len,Scale) I am trying the to load the Parameters into the target table by using substring along wi...

Hello DSguru2B: What if I checked the little box in the transformer that says otherwise / log - where I put the constraint for if not null then load into the target. then get a reject link out of transformer to a dataset. Would it then capture rows rejected other then the not null into this link? Th...

No problem. Use another DRS stage to load the same error table. Or collect your rejects in a single file and then load it to the error table in another job or so. I thought that I could create a reject link going to a seq file and in another job used this DataSet file to load into the Error table h...

An Dynamic RDBMS - DBMS Type is MSSQL server.