If one have source like col1 a a b and target like col1 col2 a 1 a 2 b 1. How to achieve this output using stage variable in transformer stage?

How to add \"0\" (zero) before record?

How can I filter data in a transformer based on a field content i.e. fiel1= *db2*?

Can transformer, aggregator stages be used to sort the data, if yes then how?

Can we sort data on a key using transformer stage in DataStage?

How to strip white space in DataStage?

Can you define a stage variable as date (datatype)?

What is "Abort After rows" property?

Is transformer a compiled component, TRUE or FALSE?

what do you understand by @INROWNUM, @PARTIONNUM, @NUMPARTITION?

How to increment a number in DataStage? Also how to create a sequence in DataStage which guarantee uniqueness?

Which stage would you use to rename/drop a column when you have a choice between a transformer and copy stage?

What character would DataStage use to pad when a variable length string is converted to fixed length string?

How to remove a carriage return character from the string in transformer stage?

What is the difference between basic transformer and parallel transformer?

What is the use of field function?

How to create a loop in Transformer stage?

How to put a footer in a sequential file through transformer stage?

If you are receiving timestamps from database, how would you remove the time part in DataStage and pass the date only to the output?

What output following derivation will result?

Subscribe to: Posts (Atom)