 Related Questions Latest Answer : You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the parameters using DSSetParam from the controling job (batch ... First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any). Latest Answer : Simply by using "usage variyable" stage in job sequencers. ... What is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while running any job? What are validations you perform after creating jobs in designer.what r the different type of errors What are validations you perform after creating jobs in designer.what r the different type of errors u faced during loading and how u solve them Read Answers (2) | Asked by : diwakar Latest Answer : Using Row Count system variable ... Read Answers (1) | Asked by : mallikharjuna reddy Latest Answer : Just go to th eparticular jobs log ... Read Answers (2) | Asked by : mallikharjuna reddy Actually my requirement is like that :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206.if we run next View Question | Asked by : sreedhar kancherla My requirement is like this :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206.If we run next time means the Read Answers (2) | Asked by : sreedhar k Latest Answer : U can also use Data stage Administrator.Just click on the project and execute command ,just follow the menu joice to get the job name and PID .then kill the process in the unix ,but for this u will require the user name of the datastage in which the process ... Read Answers (4) | Asked by : mallikharjuna reddy Why job sequence is use for? what is batches?what is the difference between job sequence and batches? Read Answers (2) | Asked by : prashant
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
