EXERCISE INDEX

Exercise 1: How to Convert Char Code to Number Code

( Source)

CODE

----------

ABCD

BCDE

EFGH

(Target)

CODE

-------

1234

2345

5678

http://informaticachamp.blogspot.in/2014/03/exercise-1-how-to-convert-char-code-to.html

Exercise 2: How to get (return) multiple values from unconnected Lookup?

http://informaticachamp.blogspot.in/2014/03/exercise-2-how-to-get-return-multiple.html

Exercise 3: How to remove duplicates? If source is a flat file

OR

How to send distinct records to one target and duplicates to others

http://informaticachamp.blogspot.in/2014/03/exercise-3-how-to-remove-duplicates-if.html

Exercise 4: How to load top 2 salaries for each department without using Rank Transformation and SQL Queries in Source Qualifier?

http://informaticachamp.blogspot.in/2014/03/exercise-3-how-to-load-top-2-salaries.html

Exercise 5: How to find sum of negative and sum of positive integer separately.

http://informaticachamp.blogspot.in/2014/03/exercise-4-how-to-find-sum-of-negative.html

Exercise 6: How to replace NULL with value and achieve target below?


(Source)
ins_id,premium_year,premium_Amount
101,2010,4500
101,2011,NULL
101,2012,NULL
102,2010,6000
102,2011,NULL
102,2012,NULL

Note: NULL is just a representation. There is no value over there.

(Target)
ins_id,premium_year,premium_Amount
101 2010 4500
101 2011 4500
101 2012 4500
102 2010 6000
102 2011 6000
102 2012 6000

http://informaticachamp.blogspot.in/2014/03/exercise-6-how-to-replace-null-with.html


Exercise 7: How to create and use Pipeline Lookup or How to create Active Lookup?

(Source)
ins_id,premium_year,premium_Amount
101,2010,NULL
101,2011,4500
101,2012,NULL
102,2010,NULL
102,2011,6000
102,2012,NULL

Note: NULL is just a representation. There is no value over there.

(Target)
ins_id,premium_year,premium_Amount
101 2010 4500
101 2011 4500
101 2012 4500
102 2010 6000
102 2011 6000
102 2012 6000

http://informaticachamp.blogspot.in/2014/03/exercise-6-how-to-create-and-use.html

Exercise 8: Implementing SCD1 and achieve target below.

Source
part_number  business_unit  business_group
01yp          unassigned            undefined
02yp          unassigned            undefined
03yp          unassigned            undefined

Target

part_number  business_unit  business_group
01yp          unassigned            undefined
02yp          HSBC                      undefined
03yp          unassigned            undefined

http://informaticachamp.blogspot.in/2014/04/exercise-8-implementing-scd1.html

Exercise 9: How to Convert Column to Row and achieve target below?

Source
CITY,NAME
BNG,JOY
BNG,LABNITA
CHE,SRINIVAS
CHE,JOYDEEP
CHE,SHRUTHI
PUNE,PRIYA

Target
CITY,NAME
BNG,JOY,LABNITA
CHE,SRINIVAS,JOYDEEP,SHRUTHI
PUNE,PRIYA

http://informaticachamp.blogspot.in/2014/05/exercise-8-how-to-convert-column-to-row.html