Interview Questionary Set 5

101. How to run same workflow with different instance in windows and unix.

102. I have a 3 flat file of same structure with different file name. While loading those file into target table using Indirect method my job got failed due to bad records. Have we are gone find out the bad records is from which file.

103. Daily based a Employee_Details file will be received and store in Infa server to process all files at the month end. I want to create a single mapping, session and workflow to load them at month end, But I cannot use File List/Indirect method due to aggregator was used in mapping.

104. Based on above Scenarios I have created a workflow which is having 31 session. Where in Jan I will be receiving 31 files, in Feb 28 file, in Mar 31 file, in Arp 30 file. So how you going to handle the loads without getting workflow failed due to exact session for the month.

105. Below each Branch having 3 sales amounts, I want Branch wise max sales amount
Source:

Branch	Sales_1	Sales_2	Sales_3
Hyd	1500	500	1000
Pune	700	1000	1200
B'lore	1000	1800	500

Target:

Branch	Sales
Hyd	1500
Pune	1200
B'lore	1800

A. Max Sales Amount of each Branch can be get easily by using function called GREATEST

Syntax: GREATEST(Sales_1, Sales_2, Sales_3)

Similarly to get Min Sales amount for each Branch use LEAST.

Syntax: LEAST(Sales_1, Sales_2, Sales_3)

106. Below each Branch having 3 sales amounts,
Source:

Branch	Sales_1	Sales_2	Sales_3
Hyd	1500	500	1000
Pune	700	1000	1200
B'lore	1000	1800	500

when I run the job 1st time my output would be like below:

Branch	Sales_1
Hyd	1500
Pune	700
B'lore	1000

when I run the job 2nd time my output would be like below:

Branch	Sales_2
Hyd	500
Pune	1000
B'lore	1800

when I run the job 3rd time my output would be like below:

Branch	Sales_3
Hyd	1000
Pune	1200
B'lore	500

A: All the above three output can be achieved by using a simple function "CHOOSE" and by parametrization $$seq=1 or 2 or 3 at the run time.

Syntax: CHOOSE($$seq, Sales_1, Sales_2, Sales_3).

Its better to call $$seq in a variable port and use that variable port in above syntax.