Latest Answer : yes you can change the column name only for oracle 9.2 and above.RDBMS: Relational DataBase Managment System ( for example a combination of object type into nested table and using this nestedtable as a datatype for a ...
Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...
Latest Answer : These are the three types of files will be created .dat, .type, .over ...
Latest Answer : It's very difficult to have a good usgae analysis in oracle and see exactly who is touching what and how on table and column level. However I know that there is a good tool called DB*Classify that provides this information and much more regarding the ...
In datastage how we can do for this type or requirement:The sales data will be extracted in 2 flat files.Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif suppose we run first time means the job names are
What is the difference between importing table definitions by Orchestrate Schema Definition or Plug-in Meta Data Definitions?
I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer.