 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 ... What are Routines and where/how are they written and have you written any routines before? Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines: 1) Transform functions Sequencers are job control programs that execute other jobs with preset Job parameters. Latest Answer : A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It can have multiple input triggers as well as multiple output triggers.The sequencer operates in two modes:ALL mode. In this mode all of the inputs to the ... 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. ... Create a Excel spreadsheet with new and old names. Export the whole project as a dsx. Write a Perl program, which can do a simple rename of the strings looking up the Excel file. Then import the new dsx Latest Answer : If you export the jobs in an XML file you can easily do a find and replace for anything using notepad. So if the standard for master is changed from mst to mstr you simply for a find and replace. Or if the jobs are jobnam_dev you and you need to ... Latest Answer : 1. Hashfile can be used as lookup but not the seq file.2. Hashfile works based on Hashed algorithm.3. The performence is more in Hashfile when it is used as a ref link(for lkp)4. we can eliminate duplicates by selecting key value in server jobs.5. Must ... Latest Answer : By using Routines we can return values but by transformers we cannot return values ... Latest Answer : An operational data store (or "ODS") is a database designed to integrate data from multiple sources to facilitate operations, analysis and reporting. Because the data originates from multiple sources, the integration often involves cleaning, redundancy ... What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this. Latest Answer : Automation of loading is supported partly in Informatica so third party tools are needed to achieve this, while data stage supports automation of loading fully. ... Read Answers (2) | Asked by : neelu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
