|
| 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 Using "dsjob" command as follows. dsjob -run -jobstatus projectname jobname Latest Answer : u can use dsjob executable command from unix or command line.The previous post was correct.Hanu. ... By using "ExcecSH" command at Before/After job properties. Latest Answer : You can specify the ExecDos Prompt in the after or before job routine. ... There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Latest Answer : From what I know there are four views1> Status 2> Schedule3> Log4> Detail. ... 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 : - I don't think these are the right numbers. Someone creating 100+ jobs in 6 months !! If you do the math - it would be 6 Months = 6 months * 22 Days * 8 Hours = 1056 hours. The above statements assume that a job would take equal to or less ... 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. ... Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters Latest Answer : hi please send me some real time questions in datastage for interview.i have interview on sunday for accenturehow do u implement rank in datastage os: windows ... 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 IConv() - Converts a string to an internal storage formatOConv() - Converts an expression to an output format. Latest Answer : iconv is used to convert the date into into internal format i.e only datastage can understand example :- date comming in mm/dd/yyyy format datasatge will conver this ur date into some number like :- 740u can use this 740 in derive in ur own format by ... 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
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
