Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using character match to filter records
Answers
-
It's not a script ... it's a technique to capture data changes and report facts at the historical view of the dimensional components.
CREATE AS SELECT <- how are you going to refresh it regularly? Your issue is solved with more than just a simple DDL statement.
Again, I come back to use of information drives data design.
0 -
I plan to create an ODI data flow to refresh the table regularly which is what is happening on the current tables.
0 -
ok ... so you don't want an INTERNS table (strictly speaking) ... you could find out who was hired as an intern first and put their ID in a table ... then skip the fact modeling and put a lookup in the employee dimension (in RPD) to set a flag indicating it ... then at least it's reusable. With the Cloud offering I'm not sure how much control you'll have to build it with EDW principles ...
0 -
Correct but the problem is once I find the interns, I need to find out who was an intern that got hired to a full time position . This is the reason I wanted to have an INTERNS table, then try figure out how to find out who was hired to full time position because there is data indicator in the warehouse that shows someone was initially an Intern that got hired to full time
0 -
Are you just validating a an existing indicator? or trying to build a new one?
0
