 Related Questions Latest Answer : XML files can be read using FOLDER stage followed by XML input stage in server jobs. ... Latest Answer : If this question means creating dummy records for parallel jobs, then 1. need to load the proper metadata to the row generator stage 2. and then supply the criteria and conditions like how the data should look like. for ex if its numeric value we can ... Latest Answer : The Question asked incorrectly.there wont be any Oracle file. It is Oracle table or view object.I never heard about Oracle input file.Can you please explain what your actual question is?Hanu. ... What is the order of execution done internally in the transformer with the stage editor having input What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links? 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. ... Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so? Yes. The following are some of the steps; I have taken in doing so:1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file2) See that you are using the same parent As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size. Latest Answer : good explanation. ... What are other Performance tunings you have done in your last project to increase the performance of What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs? Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performance also for data recovery in case job aborts.Tuned the OCI stage for 'Array Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drivers What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job. A. Under Windows: Use the 'WaitForFileActivity' under the Sequencers and then run the job. May be you can schedule the sequencer around the time the file is expected to arrive.B. Under
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
