![]() |
| 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 Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition Latest Answer : Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.Partition key is the key that we use while partition the table(in database), process the source records in ETL(in the ... 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. ... Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. Latest Answer : The default cache size is 128 MB. This is primarily used for hash file data cache in the server. This setting is only can be done in Administrator not in job level. Job level tuning is available only for Buffer Size. ... By using "ExcecSH" command at Before/After job properties. Latest Answer : You can specify the ExecDos Prompt in the after or before job routine. ... We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") Latest Answer : we can achieve this conversion using transformer stage conversion functions in PX.Hanu. ... 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. ... What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ? Latest Answer : U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecDOSor By using Command Stage Plug-In or by calling the routine from external command activity from Job Sequence. ... 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||