 Related Questions A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort. 100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody Latest Answer : Depends on which type of project you are working. Sometimes in Parallel Jobs we will take more time to finish complex job. If you have 3 years experience then you have to tell more than 100 Jobs, Few jobs in server and few in parallel ... Give the OS of the Server and the OS of the Client of your recent most project Latest Answer : server is unix and client machine i.e is ur machine where u design a job is windows xp professional ... Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different. Latest Answer : Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNER or OUTER joins, UNION, Intersection or Minus operations. ... Latest Answer : Oracle 8i does not support pseudo column sysdate but 9i supportsOracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields) ... 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 ... 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 ... Scenario based Question ........... Suppose that 4 job control by the sequencer like (job 1, job 2, job 3, job 4 )if job 1 have 10,000 row ,after run the job only 5000 data has been loaded in target table remaining are not loaded and your job going to be aborted then.. How can short out the problem. Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this condition should go director and check it what type of problem showing either data type problem, warning massage, job View Question | Asked by : Mukesh Kumar Madhav
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
