DSXchange

I developed a parallel job Reading using External source and it has 7 transformers, 1 join stage and 3 target datasets, 1 Lookup reading using external source stage. I write the reject records to error log table which is teradata. The issue is when I ran this job yesterday with 3.9Million records fr...

Yes , it does return rows when i do a select on that table. but I think i am unable to insert right?

Tera_Con_ENGR_ITM_VERS: [IIS-CONN-TERA-005009] Query returned 0 row(s). SQL statement: LOCK ROW FOR ACCESS SELECT TRIM(TableKind) FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm' (CC_TeraConnection::getTableKind, file CC_TeraConnection.cpp, line 1,714) When i try to Load dat...

Thanks, I will have mutiple records how do I read only 1 record using the Awk Command.

Hi, I have a requirement to execute the Unix command and pass the value the next JobActivity In the Execute command how do I pass the two unix commands awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' #ps_EDW_StdHrs.p_Source_Dir#/*/#ps_EDW_StdHrs.p_Source_FileName# | cut -d"|" -f8,9 He...

anbu wrote:Did you assign svNum to Target field?

I have used svNum as stage variable and assigned the stagevariable to target field as constraint.

Thanks for responding.

anbu wrote:

Code: Select all

svNum=Trim(Convert('+-','',Input))

Use this as transformer constraint

Code: Select all

Len(Field(svNum,'.',1)) < 4 And Len(Field(svNum,'.',2)) < 3

I can still see the signs in output file. convert is not working.Help me Please.

Thanks in advance.

Hi,

I have a decimal(7,3)
eg: +1234.567 or -1234.567 need O/p as 1234.567

Also IF more than 4 positions to left or more than 3 positions to right reject.

eg: +12345.67 reject
+123.4567 reject

How to implement this can any one help me am new to datastage!