Interview Questions

Return Code in JCL can b obtained by the use of COND paramater...it is used to know the return codes of previous steps.

$message is a variable with a fixed name. $$message is a variable whose name is stored in $message. 

If $message contains "var", $$message is the same as $var.

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.

- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.

- Interviewees also have to be aware of different time zones and server time zone.

-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

ActiveX DLL:

It is an in process server. It runs within the application time.

ActiveX Exe:

It is an out of process server. MS-Excel is an activex exe.

when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that.

The 4 key phases of business development are: Forming, Storming, Norming and Performing.

EFT-Electronic Funds Transfer is basically batch of payments are transferring from one bank to another bank with specified time lines.  EFT payments are also called as BACS if it is UK, ACH in US for domestic payments.  Foreign payments are called as SWIFT payments.

WIRE: Wire can be used to release payments for local or international, Different countries will be named in different ways viz., CHAPS for Local Payments made in UK, WIRE for all international payments made from UK and Local & foreign payments made in all other countries

Cloud computing is a metaphor used for internet. It provides on-demand access to virtualized IT resources that can be shared by others or subscribed by you. It provides an easy way to provide configurable resources by taking it from a shared pool. The pool consists of networks, servers, storage, applications and services.

3 way matching is to compare three documents i.e., 

1. Purchase order

2. Receipt of Items/Packing slip 

3. Invoice. 

For example, if we Order for 50 Items in purchase order and received 40 Items only instead of 50 items. But we received invoice for 50 items. After comparing the three documents we pay for only 40 Items..