Column Value as constraint or filter in datastage
Posted: Tue Jul 22, 2014 6:28 pm
Hello Gurus,
Need your expertise idea to crack below requirement.
I have lookup table where i have maintained condition or constraints
Like E.g
Table1
Key V_SQL
1 Name = 'P'
2 Name = 'Q'
So I will join the main data with lookup table based on the key and pass the value has constraint or condition in datastage at runtime.
So if i have 500 constraints ,I can maintain the same in lookup table instead of writing 500 constraints .
The only reason to maintain the lookup table is not touch the datastage code very frequently.
Any solution well appreciated and thank In Advance.
Need your expertise idea to crack below requirement.
I have lookup table where i have maintained condition or constraints
Like E.g
Table1
Key V_SQL
1 Name = 'P'
2 Name = 'Q'
So I will join the main data with lookup table based on the key and pass the value has constraint or condition in datastage at runtime.
So if i have 500 constraints ,I can maintain the same in lookup table instead of writing 500 constraints .
The only reason to maintain the lookup table is not touch the datastage code very frequently.
Any solution well appreciated and thank In Advance.