Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. glenpark

    Number of day in a quarter?

    Yeah I'm not sure if those days change or not...I checked a calendar for 10 years worth of dates and it looks like it doesn't. So I created a case statement similar to yours only it just looks for the month and day for those specific end of quarters regardless of year: case when...
  2. glenpark

    Number of day in a quarter?

    There's a column I'm filling in which is basically a flag to mark which dates are the last date in a quarter. Whenever a date comes up, I just mark the column 'Y' while all others are 'N'. Are you sure these particular dates never change? If so, then that makes is much easier.
  3. glenpark

    Number of day in a quarter?

    Thanks Marc, that statement worked perfectly! It's exactly what I needed. I'm basically writing a stored proc that'll fill in this insane date/time dimension table...it's done for the most part except for a couple problematic columns like this one. I don't suppose you have a solution for...
  4. glenpark

    Number of day in a quarter?

    Yeah I thought of that originally but then I realized it may not work....I have to account for the years 1900 to 1984. I'm going to run into the whole leap year issue so some years will have a different number of days. *barf* lol Thanks for the suggestions guys
  5. glenpark

    Number of day in a quarter?

    Hey everyone, I've been working on this concept for a little while but still having trouble knocking out a solution. Based on a timestamp, is it possible to extract what number of day it is in a quarter? For instance, January through March of 2007 would be quarter 1 and hence February 2nd...
  6. glenpark

    Help with Export/Import statement

    I did a little searching but didn't find exactly what I was looking for. Would there be a problem with doing an EXPORT of data from a table into a flat file, adding a column to the table, then executing an IMPORT into that table? Assuming that new column is non-nullible and carries a default...
  7. glenpark

    Problem with dynamic cache

    Hey everyone, I'm having some trouble with a dynamic lookup. I'm betting that it's just a small problem but I just can't see it so I need another pair of eyes. Here's the problem: The dynamic lookup is on the target table in a mapping that loads a type 2 slowly changing dimension. It...
  8. glenpark

    Variable-depth hierarchy

    Yeah I'm finding that the answer doesn't sound so easy. If I knew how many levels beforehand, I could use a normalizer transformation. I'll keep looking around, if I find a solution I'll post it up here. Thanks
  9. glenpark

    Variable-depth hierarchy

    Hello again, So now I have a bit more of a difficult problem to solve. Has anyone had to deal with a variable-depth hierarchy? I have one as a source and have to load it into a type 2 SCD. Looking around online, I see references to this but they all seem to only be taught in paid courses...
  10. glenpark

    Same table in source and target

    Thanks, I'll give it a try. The only exception looks like will be switching to a dynamic lookup as I may be confronted with a historical load of that table.
  11. glenpark

    Same table in source and target

    Hmm...maybe I'll try it then. The view also contains the primary key from the target table. Sometimes it's null because the row doesn't exist in the target table yet. Perhaps I can use that as an easy indicator for an insert or update. How are you checking for changes? Via lookup against...
  12. glenpark

    Same table in source and target

    Well I'm back again =D So I have a conceptual question... I've been given a source and target for a mapping that involve the same table. The source is actually a view made up of columns from two tables, one of which is also my target table. My question is regarding whether there's any danger...
  13. glenpark

    Shared dynamic cache?

    Actually what I meant was is it possible to use an unconnected lookup that would refer to a cache created by a connected dynamic lookup? In this way the static, unconnected lookup would always be looking at an updated source of data instead of directly at the target. But I'm not sure if this...
  14. glenpark

    Shared dynamic cache?

    Hello, Ok so I need a little help with a problem conceptually here. I'm constructing a mapping that loads a type 2 slowly changing dimension. Which means I have to use a dynamic lookup against the target table to synchronize inserts/updates between it and the lookup cache. Now, I have...
  15. glenpark

    Error in expression editor

    Found a solution. I just ditched the IIF and went with a DECODE statement. DECODE(true, conditionA = 1, UpdateDate, conditionB = 1, null, conditionC = 1, null)
  16. glenpark

    Error in expression editor

    I just checked the Informatica help, the else is optional. Just in case, I tried putting in an else condition but still got the same error. Also tried converting the UpdateDate into a string first then feeding it into the variable port, no dice. This problem is pretty perplexing =/
  17. glenpark

    Error in expression editor

    I thought an else condition is optional for an IIF? UpdateDate is a date/time datatype. But I think it can be converted into a string when moved from one port to another.
  18. glenpark

    Error in expression editor

    Hello! I'm running into an error message in the expression editor when running this IIF statement: IIF(conditionA=1,UpdateDate, IIF(conditionB=1 OR conditionC=1,null)) All three conditions are small int variable ports. This IIF statement is contained in a variable part that is string...
  19. glenpark

    Command Tasks and File Detection

    Do I really need to use a decision task for this? What about putting the command into the command task "ls $sourcefiledir/filename.txt" Then in the following link, set "STATUS != 0" and an email task connected to it? So it would look like this: Command Task(command1='ls...
  20. glenpark

    Command Tasks and File Detection

    I can't seem to find a similar situation on here so here I go. I'm running INFA 7.x on Linux and need to use a command task to detect a flat file before running a workflow. I can't use an event wait because the workflow needs to run whether the flat file is there or not. So basically when the...

Part and Inventory Search

Back
Top