DSXchange

I see you've marked the topic as Resolved, what was the answer?

By starting your own thread over in the PX forum, of course!

Ah... orchdbutil not the admin command. Or you can just go off the menu and let it run the command for you:

Import > Table Definitions > Orchestrate

From what I understand, the 'orchadmin' command does a better job with metadata for the PX product. Pretty sure that's it... orch-something-or-other.

How did you import the metadata? Meaning, what tool did you use?

If you've only got 4 runs in the log, that's all you can go back now. 4 runs, not 30 days. If you start extracting them you can keep that information for as long as you like. Going forward. Search for 'ETLStats' in the forums.

Ok, sorry... the reference to sqlplus threw me and didn't realize we were talking about a Windows database. [sigh] Right, as noted there is no UNIX command line utility for this. You either need to use ODBC or get a data file transferred over to the Windows server and load it using the command line ...

None. More of a informational / metadata thing, if anything, for you to mark the 'key' columns. Got nothing at all to do with duplicates on the target side, especially in a sequential target. You will need to handle / remove the 'duplicates' in the source data in your job design. How you manage that...

rumu wrote:I asked my DBA but it seems he is not aware of this ....he has to look into that

You've got to be kidding me. Get a better DBA.

Obviously, "redefines" are not allowed, the error message clearly states that. Have you searched the forums, this isn't the first time someone has asked this question.

Completely different. The XML Transformer parses XML when you need to do that in the 'job flow' rather than as an end point. And if you leave the XPath Expression blank, that field will be a 'pass through' field. Not sure if that answers your 'hardcode' question or not.

Welcome aboard. :D

While you could certainly connect to a service they expose, there's no built-in mechanism to read / connect to an http source. AFAIK.

You can't.

Can you search first? Read the posts here on the pivoting technique, give it a try and then come back with specific questions.

You need to get rid of whatever process has the job. It could be as simple as someone browsing the job's log. Did you get the job's number and look for it in Cleanup Resources?