DSXchange

Ernie, Here is how it looks after I create the shared table using the Shared Table Wizard in DataStage. And we don't have MWB so am not sure how it looks in that workbench. DSR.HR_UNITS Source Table Definition: Data source type: ODBC Data source name: DSO Table/file name: DSR.HR_UNITS Description: C...

Thanks Ernie, I was actually able to create shared tables from the Table definitions in Data Stage with no problem at all. But my problem was access to those tables from Fast Track. In the Fast Track tool, there seem to be only 2 ways to import metadata 1) Import from Metadata Repository 2) Source C...

Great Ernie !
I was able to create the shared tables from DataStage, but was not able to access those tables in Fast Track - i tried both the 'Metadata Repository' and 'Source Configuration' options.
Can you please advise me on this

thanks for your response Ernie. We are using the regular Orchestrate import option in DataStage and all works fine in Datastage. per your suggestion, i tried to use the Oracle Connector (11) in DataStage and got the exact same error message as i got in Fast Track. I suppose we can try the ODBC Conne...

Hi, We just bought the Fast Track tool and am trying to import the metadata (source and target tables) into it. But am stuck on the Source configuration interface unable to figure out which one to use to make it work. Basically our application server is on Linux, our data resides on Oracle 11g datab...

Well, our team was in a hurry to restore it ASAP and i didn't have enough time to work on this repair, would love to know more on how to do this though. What we finally ended up doing was restore from system backup, where we lost a week's worth of development (not a whole lot in our case, since it w...

Ray,
I looked in one random RT_CONFIG directory and it did have all the 3 files as you mentioned.

however, there are some DS_* that do not have any of these 3 files. Most have those 3.

The following have all the 3 - DS_JOBS
DS_ROUTINES - does not have the .Type3 (has the other 2)


Thanks
Jyo

Also, I have the following I_* files as well

I_DS_JOBOBJECTS:
INDEX.000* INDEX.001* INDEX.002*

I_DS_JOBS:
INDEX.000* INDEX.001* INDEX.002* INDEX.003*

Thanks,
Jyo

thanks Ray,
I actually tried that - DS.REINDEX ALL
but got the error as

File 'DS_JOBS' has no indices
Secondary index facility is not supported for type 1 or type 19 files.
It continued on for all others like 'DS_ROUTINES', 'DS_STAGETYPES' etc

So, we don't know how it happened, but all jobs in a project are now missing. When we login to Designer or director, we just don't see any jobs there. I did a LIST DS_JOBS and all of them show up. so, i am kind of hopeful that the error is related to some dictionary, repository listing, index issue....

Hi, I have a job that reads about 92 million records from a source table and loads it to a oracle table. I have the target stage in this case have a LOAD/Append option. I did not set the DIRECT=TRUE. But this job takes forever and i am trying to figure out if there is a way to speed up this load. Th...

Does the stage variable have the same data type as the target column?

[quote="bensonian"]
Source Name = #db_server#.#db_name#.#schema#.<table_name>

[/quote]

The source name here should not be the <table_name> but the oracle sequence name. The oracle sequence should be already created in the DB

I had similar problem, but though it doesnt make sense, i added a modify stage inbetween the transformer and Oracle Load, and just a dummy specification like <in_col_name> = <out_col_name> and it works for me, no more errors. for eg: in your case, if the column name coming from sequential file is FI...

Yes hello105, you are right. When i set the partition table option while using a user-defined SQL query that joins multiple tables, I end up with duplicates. The data read becomes faster, but to avoid the duplicates if we add a remove dups stage, it slows down again negating the speed that i achieve...