Goal : To get the data from two columns which have transitive relationship between them
A -> B
B -> C
then
A -> C
| Input | |
| Col1 | Col2 |
| a | b |
| b | c |
| s | u |
| u | p |
| 1 | 2 |
| 2 | 3 |
| Output | |
| Col1 | Col2 |
| a | c |
| s | p |
| 1 | 3 |
Like the below page to get update
Thursday, December 22, 2016
DataStage Scenario #17 - Get Transitive relation between columns
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment