DSXchange

Hi, I have parallel job which uses Schema file and Run Time Column Propagation functionality. Job Design as below Seqential File-->ColImport-->Transformer-->ODBC Connector. It is loading the data but it is throwing warnings for each field in Schema File. Just to let you know there are no transformat...

Hi

I have requirement to load files which have been encrypted by third party applications and Keys will be provided to ETL Team. So using those keys, Datastage need to read the data from file and load into table.

Is it possible in Datastage at all?

Thanks Everyone.

Hi Will there be any difference in performance when we read file as single column using Sequential File Stage and then use column import stage to divide the multiple columns and Reading the file as multiple columns using Sequential File Stage and do the rest of the transformation process. Thanks Naga

Thanks Kryt0n, i thought there will be solution in Schema File.

Hi, I have Common Job which extracts the data from multiple files with n number of fields. In Job, we use Column Import Stage with Schema File to import into multiple fields as we initially read file as single field. When we do testing we send more no. of delimiters(|) than expected(Eg: we have two ...

that works !! but I want to make the job abort when it fails to update atleast one record.

Research "transaction isolation level". Thanks Ray, I had gone through the docs and found Repeatable Read Isolation level. And have few queries on this. As it says, It locks the row(whichever has been read) does it allows to update the in the same process( i mean reading as reference and ...

Hi

I have requirement to extract data from table(which is common to many processes) and update the same table But in the mean time no other process should read the same data and update. We are doing this in single Job.

Could some one advise on this how to achieve this?

Thanks
Naga

Thanks Ray.
Correct One

record
(
Number:decimal[5,2] {cycle={init=000.00, incr=0}}
)

Try it with no space between the "]" and the "{". Thanks Ray, But still i am getting the same warning message and same data incrementing with 1. Column_Generator_12: Field Number of type decimal[5,2]:: unrecognized generator parameters ignored: . I thought of generating this fie...

Hi I want to create new column with default value using column generator stage using schema file. i tried with below schema file, but it has not created with default value( i gave in the schema). It has incremented by 1 starts with 0. record ( Number:decimal[5,2] {default=000.00}; ) Could someone fa...

Hi I have job which creates multiple datasets, One column name is same in each dataset.. and these columns are mapped by one column. Eg: input column Output Column column_name COLUMN_NAME COLUMN_NAME COLUMNA_NAME i am getting warning when i execute it. error as below. Tfm_Derivation: When checking o...

Hi I have created simple c++ code with the help of Google. and compiled successfully in Unix server. Create routine in Datastage. I called the routine in Transformer and tried to compile, but it is not successful and saying that Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 13...

Yeah, we can do that.

But i need to gather few more link row counts as well. along with some other Audit related information.

that si the reason i am going for Routine.