 Related Questions 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 : I will explain how to Convert a mm/dd/yyyy format to yyyy-dd-mm Below is the format Oconv(Iconv(Filedname D/MDY[2 2 4] ) D-YDM[4 2 2] ) here first Iconv(Filedname D/MDY[2 2 4] ) will convert our given date in the internal formatlater Oconv( ... 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. ... 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 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 Functions like [] -> sub-string function and ':' -> concatenation operatorSyntax: string [ [ start, ] length ]string [ delimiter, instance, repeats ] Starting from DS 6.0 we have the ability to call external Java functions using a Java package from Ascential. In this case we can even use the command line to invoke the Java function and write the return Latest Answer : Use the Java PACK. Java Pack has Java Client and Java Transformer Stages. YOu can write your own class and call it from either from Client or Transformer stages. ... What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director? Use crontab utility along with dsexecute() function along with proper parameters passed. 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
