Can anyone tel me how to use a file to fetch the parameter values for a parallel job in datastage as i don't want it to be hard coded.The format for the file shall be (name,value) pair. please help
Latest Answer: In Datastage sequence, there is a stage named "UserVariable_Activity", this can use to fetch the parameter. Create a new user variable in the uservariable_activity stage and for the expression part of it, you can simply give your parameter ...
How do you you delete header and footer on the source sequential file and how do you create header and footer on target sequential file using datastage?
Latest Answer: By using UNIX sed command we can delete header and footeri.e; for header sed -n '1|p'and footer sed -n '$|p' ...
Latest Answer: 1. decrease usage of transformer stage.2. use sorted input for aggregator.3. Filter the data in source itself(if it is oracle database, write user def sql)4. use tunables tab in Administrator for cache memory, buffer size,...( if u have knowledge-- if ...
Latest Answer: can u explain with example(SCD2), i think this can solve real time guy but not meaning and definition. can any one take example and explain clearly. ...
Latest Answer: Used to run jobs from the command line, we can all use dsjobs to get log info about the job. ...
Latest Answer: use CDC, lookup, trasformer stages to impliment SCD2. In CDC just give the changed values and key column, then capture the changed records, in transformer just give the constraint for 0,1,2,3(del,insert,copy,updated data), u will get inserted data ...
Latest Answer: Hash files are available only on DS-Server ...
Want to convert Char to timestamp in transformer stage. Can anybody please tell me what conversion function I need to put in derivation?
Latest Answer: In both stage create one extra port and assign the value of those port is 0 then join it.but best option is allready suggested that use Transformer stage and map required column. ...
Latest Answer: Here in datastage there are some warnings and some fatal errors will come in the log file. If there is any fatal error means the job got aborted but if there are any warnings are there means the job not aborts but we have to handle those warnings ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
