ETL jobs from the UNIX command line?
Ans: Try dscmdexport and dscmdimport. Won’t handle the “individual job” requirement.You can only export full projects from the command line.You can find the export and import executables on the client machine usually someplacelike: C:\Program Files\Ascential\DataStage.Question: Diff. between JOIN stage and MERGE stage.Answer:JOIN: Performs join operations on two or more data sets input to the stage and thenoutputs the resulting dataset.MERGE: Combines a sorted master data set with one or more sorted updated data sets.The columns from the records in the master and update data set s are merged so that theout put record contains all the columns from the master record plus any additionalcolumns from each update record that required.A master record and an update record are merged only if both of them have the samevalues for the merge key column(s) that we specify .Merge key columns are one or morecolumns that exist in both the master and update records.
