Staging table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Staging table
Hi All,
I have to create staging table. That has to be done by entering custom SQL which is a bit complex as it has many joins. Can any body suggest how shall I proceed ?
Database is Oracle.
Can I do it by TOAD or DS ?
Thanks.
I have to create staging table. That has to be done by entering custom SQL which is a bit complex as it has many joins. Can any body suggest how shall I proceed ?
Database is Oracle.
Can I do it by TOAD or DS ?
Thanks.
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Join is not a problem other parameters are to be checked. Its like 3 to 4 tables. And I need a staging table to store this. So my question is , is DS required for this purpose or i can do it in TOAD ? To build staging table...
Thanks
Thanks
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Re: Staging table
To create the table use DDLs, run it on database. no need of datastage.urshit_1983 wrote: I have to create staging table.
Even to populate the table, use oracle if you have no major transformations to be done on the data and you just need to make some joins and populate the staging table.
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Re: Staging table
Ok so Data stage does not come in the picture then. So the steps:
Create Table using TOAD
write required SQL
populate the table with required columns
Right ??
Create Table using TOAD
write required SQL
populate the table with required columns
Right ??
"Nobody is expert in Everything,
But Everybody is expert in Something."
But Everybody is expert in Something."
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Hi urshit_1983,
Sorry, The way I took the question was different.I can suggest you the same as Krazykoolrohit..
Sorry, The way I took the question was different.I can suggest you the same as Krazykoolrohit..
Thank youurshit_1983 wrote:Join is not a problem other parameters are to be checked. Its like 3 to 4 tables. And I need a staging table to store this. So my question is , is DS required for this purpose or i can do it in TOAD ? To build staging table...
Thanks
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Re: Staging table
Not untill you have some transformations to be done on data. If you are just populating the tables, datastage may become an overhead for you.urshit_1983 wrote:Ok so Data stage does not come in the picture then.
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ
Like already discussed above
If your purpose is to create a staging table, without any transformations, you could do it using TOAD.
Create a table with the required coulmns.
Insert the results of your query into the table using
The number of coulmns/datatype of columns in your table has to match the number of columns/datatype of your query output
If your purpose is to create a staging table, without any transformations, you could do it using TOAD.
Create a table with the required coulmns.
Insert the results of your query into the table using
Code: Select all
Insert into <table-name>
(
<Your complex query>.
)
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
Or simply:
Two birds, one stone. DataStage is perfectly capable of creating any table you have the grants to create in TOAD. As to if you should use DataStage, that depends somewhat on what you are accomplishing here. A one time 'staging' of data? No, you're fine via TOAD. Something you'll need to 'stage' on a regular basis? Then yes.
Code: Select all
CREATE TABLE AS
(your query)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 73
- Joined: Wed Jun 28, 2006 3:27 pm
- Location: NJ