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.
Column Value as constraint or filter in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
You missed the whole point, I'm afraid.
Pradeep, do an exact search here for "rules engine" to get an idea what can be involved. Most are older discussions but still relevant I believe. You'll also find mention of third party tools like ILOG JRules which is now part of IBM as BRMS.
Pradeep, do an exact search here for "rules engine" to get an idea what can be involved. Most are older discussions but still relevant I believe. You'll also find mention of third party tools like ILOG JRules which is now part of IBM as BRMS.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers