DSXchange

chulett wrote:Please explain what "remove duplicates more than 1 column" means.

Until Arshi comes back and clarifies things, you are all just guessing. I don't know about you, but I don't like to have to guess what the problem is that we are trying to solve so I'm perfectly content to wait.

Weird. That's way too fatal, it didn't even have time to write the entire message out it seems. Best to open a case with your official Support provider for this, if you haven't done so already.

I don't see a need for a routine per se, there's no unknown component to the filenames. Just generate them based on the year/month and then pass them in as job parameters.

I don't think there will be anything "optimal" about an ETL solution to this problem. This is really a DBA task to validate "backup" databases. And as far as I know, if you really want to go down this road you will need 122 jobs for this... but at least they will all be very very (very) similar. Set...

"Avoid" how? Don't insert the record? Convert the null to something else? First task is detection with IsNull (typically) then either constrain or transform based on the result.

What database? Most come with tools, or third-pary tools exist for tasks like this. It would be cumbersome and time-consuming to accomplish this via ETL, I would think.

Search the forums for COMO (specifically &COMO&) that will help with #1. However, all this is server side stuff, not client, so you'll need to transfer the results back to wherever you need it.

laknar wrote:Im not able to insert new records when we load first time.

Why not? What happens, what error(s) are generated? Details.

Project Name comes before Job Name on the command line and "-jobinfo" does not include category. You need to query the repository:

What new version, exactly? And is the server changing as well? That will affect the answer.

Hmmm... I don't hear anything that says "loop" to me unless you are saying you need to run a single job 90 times, once for each date? Can you not just build a normal job and process all dates in the quarter in one run?

Please do not post the same question multiple times, and especially do not hijack other's posts. And Server or PX, which is it?

PX post is here:

http://www.dsxchange.com/viewtopic.php?t=121121

Do you literally need a looping structure? Will you process a single date at a time for the quarter or all dates in the range noted in a single iteration? Look into using a Sequence job to get the date range, what happens after that depends on your need.

Details, please. Explain the details of your job design and what exactly you are trying to find out by posting here. Is your job working but you are looking for alternate designs for some reason? Be precise. When we load the records first time into the dimension table. And? Incomplete sentence.

amarnadh0203 wrote:ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

thats all i can see in the event log window...

One last time for grins...

Didn't ask what you can see, I asked you to click on 'Copy' and then paste everything from the clipboard (Ctrl-V) to a message here.