|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : 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 : Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's depends on what you are tring to accomplishwhat are the requirements for your ETL tool? Do you have large sequential files (1 million rows, for example) that ... Read Answers (1) | Asked by : neelu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
