It is a processing stage that supports n inputs and 1 output.
Combining Source 1 and Source 1 without any key dependency
We have 3 Funnel types
It is having multi-purpose
Load
E id E Name Add
11 A HYD
22 E SEC
E id E Name Gender Sal Add
33 B 1 23000 HYD
22 C 0 22000 Del
Column to Generate = COUNTRY
Column to Generate = COMPANY
Output
Do Mapping (link 13)
outputDump (link)à do Mapping
Now,Output
Funnel (link)
Do Mapping
Remove DSlink 13.COMPANY / DSlink 13.COUNTRY
Go to Columns
if any column Name changes have to be mode, do it here.
funnel Type = Continuous funnel
Output
Do Mapping
Data set 0
E id | E Name | Add |
33 | B | HYD |
44 | C | DEL |
11 | A | HYD |
22 | E | SEC |
E id | E Name | Gender | Sal | Add | Country | Company |
33 | B | 1 | 23000 | HYD | aaa | aaa |
44 | C | 0 | 22000 | DEL | bbb | Bbb |
Data set
Load primary.txt
Load ref.txt
In both primary.txt and ref.txt Columns
State
àMap State Drag and Drop Required Columns
Go to Constraints
Set reject
Column to Generate = STATE – DESCOutputàDo Mapping
Columns
Right click on STATE – DESC
Algorithm = Cycle
Value = not applicable
Apply
Close
Compile And RUN
E id | E Name | State | Status | State - desc |
11 | SUMAN | AP | 1001 | Andhra Pradesh |
22 | MOON | TN | 1000 | Tamil Nadu |
33 | SUMAN | AP | 1111 | Andhra Pradesh |
55 | SUMAN | AP | 1101 | Andhra Pradesh |
66 | MOON | JK | 1001 | Jammu Kashmir |
77 | MOONSUN | AP | 1011 | Andhra Pradesh |
E id | E Name | State | Status | State - desc |
44 | MOONSTAR | NN | 1011 | Not Applicable |
88 | MOON | MP | 1111 | Not Applicable |
Data set 1
E id | E Name | State | Status | State - desc |
11 | SUMAN | AP | 1001 | Andhra Pradesh |
22 | MOON | TN | 1000 | Tamil Nadu |
33 | SUMAN | AP | 1111 | Andhra Pradesh |
55 | SUMAN | AP | 1101 | Andhra Pradesh |
66 | MOON | JK | 1001 | Jammu Kashmir |
77 | MOONSUN | AP | 1011 | Andhra Pradesh |
44 | MOON STAR | NN | 1011 | Not Applicable |
88 | MOON | MP | 1111 | Not Applicable |
Inclined to build a profession as Datastage Developer? Then here is the blog post on, explore Datastage Training
While using lookup, We Can Write the conditions in Constraints
That is Generally when we take 2 sequential files
1.primary and 1 reference file, we can Write Conditions for the only the primary file
Link Name Condition Condition Not Met Lookup failure
Ref Drop Drop
Right-click Input column
primary
Load primary.txt columns
state
Load ref.txt columns
state
Load rfe2.txt columns
state
Status | Status- desc |
1001 | Married |
1000 | Divorced |
1111 | Single |
Drag State from primary to ref
Drag Status from primary to ref 1
Now, Drag and Drop required Columns
Click on Constraints
Link Name | condition | Condition Not met | Lookup failure |
|
Drop | Drop | |
2.ref1 | Drop | Drop |
Right clickInput Column
ref
ref. State –desc = “Andhra Pradesh”
Now, Compile And RUN
E id | E Name | State | Status | State - desc | |
11 | SUMAN | AP | 1001 | Andhra Pradesh | Married |
33 | SUMAN | Ap | 1111 | Andhra Pradesh | Single |
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.