DSXchange

Hi, The SCD Type 2 design works fine but I have a requirement : When I load my fact tables, I will do a range lookup to check what was the correct reference at the time of the fact. To me, this range lookup can only work if, when the record is NEW, the effective date should be 01/01/1901 and not the...

I needed to convert to date using a modify stage first

Also had forgotten to trigger the 'a..z' range condition.

It works great, thanks a lot.

The range can work either way, two things to check (that spring to mind) 1) Have you got your >=/<= the right way round? 2) Are you getting warning messages in your log regarding duplicates? If so, you may find you are losing the range that you want, particularly an issue if you are working off ano...

This is the example I'm mentionning

This is the opposite of what I would like to do (start date and end date are on the main link, I want them on the ref link)

PadString with 'A' as the pattern and 3 as the length I'd say

Hello guys, I have trouble using the range lookup feature from the lookup stage. I've seen an example on the web but it is not what I would expect. My problem is easy 1) I have a main flow which contains a calendar_date (Date Format) out of a row generator (i create a calendar table). 2) I have a lo...

That is the strategy that I have used too. The only other method I have come up with that makes it possible to determine which specific lookup failed is to have a series of lookup stages - with one reference link per lookup stage. The reduction in stages and the increased flexibility of using the '...

True, but maybe he could tell us how much he needs because 38 digits, man, that's a lot.

I send the output lint to a copy stage.

Done.

Correct me if I'm wrong but cannot you use Integer type instead of decimal ?

Hello people, I would like to discuss with you the best strategy for having multiple lookup with multiple reject links. i think many of us have this issue so I found useful to discuss it. Here is what I have done and propose : I have a primary link with N keys that I have to check (on reference tabl...

Thank you, this answer my question.

Then I don't have to bother to create a lookup directly from Oracle reference sources.

I suppose this is the main difference with previous versions where it was strongly recommended to insert intermediate datasets.

Good day all

nagarjuna wrote:It depends on amount of data that you are handling ...How much data you will have in reference link ??

My biggest dim is about 150,00 records but the average is below 10,000.

Have you actually tried? It is very possible to use an oracle stage directly as a referential input to a lookup. Hi ShaneMuir, Yes I have Just want to know if it takes down performance or not. In other words, is it compulsory to create the datasets to avoid performance drop ? I heard the wew versio...