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...
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.
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...
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
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...
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...
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...
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
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...
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.
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...
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...
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...
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...
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)
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 =/
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.