Question: Input-1: 1 2 3 4 5 6 Input-2: 4 5 6 7 8 9 Output-1: 1 2 3 Output-2: 4 5 6 Output-3: 7 8 9Solution: This problem …
If sequence has 4 jobs, How to restart the run from 2nd job again? Answer: Using check point concept to make it restart. Difference between Resource Disk and Resource Scratch …
RANK Function: RANK function returns the rank of a value in a group of values. It is similar to DENSE_RANK function. The rank function can cause non-consecutive rankings if …
Difference between Procedure and Function? Function must return a value and procedure need not. Function can be used in SQL queries with some restrictions. Procedure cannot be called directly …
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. To simply put, an index is a pointer to data in a …
The .odbc.ini file gives information about connecting to the database (wire protocol drivers) or the database client (non-wire protocol drivers). If your system uses a mix of drivers, your …
The Datastage configuration file is a master management file (a text file which sits on the server side) for jobs which describes the parallel system resources and design. The configuration …
If you are migrating an existing DataStage™ server on a UNIX® or Linux® computer, you must save copies of certain configuration files. The environment variable $DSHOME identifies the engine …
