Scenario12

There are 5 columns in a flat file, How to read 2nd and 5th columns only..

Scenario11

Difference between Trim, Trim B, Trim L, Trim T, Trim F, Trim Leading Trailing, Strip White Spaces..

Scenario10

How to abort the job after 50 rows are processed (assume there are 500 records available in a flat file)..

Scenario9

How many ways are there to perform remove duplicates function with out using Remove duplicate stage..

Scenario8

How to find out First sal, Last sal in each dept with out using aggrigater stage

Scenario7

How to calculate Sum(sal), Avg(sal), Min(sal), Max(sal) with out using Aggrigator stage..

Scenario6

Input is like this:
file1
1
2
3
4
5
6
7
8
9
10

Output is like:
file2(odd)         file3(even)
1                      2   
3                      4
5                      6
7                      8
9                      10

Scenario5

Input is like this:
file1
10
20
10
10
20
30

Output is like:
file2               file3
10                  30
20 

Scenario4

Input is like:
file1
10
20
10
10
20
30

Output is like Multiple occurrences in one file and single occurrences in one file:
file2      file3
10         30
10
10
20
20

Scenario3

Input is like this:
file1
10
20
10
10
20
30

Output is like:
file2               file3(duplicates)
10                  10  
20                  10
30                  20 

Scenario2

input is like this:
no,char
1,a
2,b
3,a
4,b
5,a
6,a
7,b
8,a



But the output is in this form  with row numbering of Duplicate occurence


output:

no,char,Count
"1","a","1"
"6","a","2"
"5","a","3"
"8","a","4"
"3","a","5"
"2","b","1"
"7","b","2"
"4","b","3"

Scenario1

Input is like this :
i/p
col1,col2
101,a
102,b
103,c
104,d

Output need to be:
o/p
col1,col2
101,d
102,c
103,b
104,a

Differences between Filter & Switch

Filter:

• It receives the data from one input link and send it to any no.of out put links.
• It filters the records based on one or more where clause conditions.
• Here every incoming record checks all the where clause conditions. So one input record goes to multiple output links.
• Fallowing keywords are valid in defining where clause conditions  =,<,>,<>,<=,>=,AND,OR,NOT,BETWEEN
• Output Reject = True or False.

Switch:   

• It receives the data from one input link and send up to 128 output links.
• It filters the records based on one or more case conditions.
• Here every incoming record goes from one case condition only.
• It supports only for equality operator.
• If Not Found =Drop / Fail / Output.

Difference between Lookup, Join and Merge

Lookup stage supports:

• One stream input link
• 'n' reference links(n=1 to ...)
• one output link
• one optional reject link

Join stage supports:

• one Left set 
• one Right set
• 'n' intermediate links(n=0 to ....)
• one output link
• no reject links

Merge stage supports:

• one Master link
• n-update links(n=1 to ...)
• m-optional Reject links(m=0 to n)
• one output link

In Lookup we can apply Conditions. But in Join & Merge not possible to apply Conditions
In Lookup joining columns may not be with same name. But in Join & Merge Joining columns must be with same name