Unable to migrate data from unidata to oracle
Moderators: chulett, rschirm, roy
Unable to migrate data from unidata to oracle
Hi,
I would like to upload the data from Unidata Database to Oracle. Here when I open the data from Datastage job, it is showing few records say 5 or 6 records while it is showing all the records say 10,000+ records in the Unidata database. I must admit that there is one column in this table. While running the job data is not getting uploaded. This is the same case with all the tables which are having one column. Here column is ID and it is primary key.
How to resolve this ?
Regards,
I would like to upload the data from Unidata Database to Oracle. Here when I open the data from Datastage job, it is showing few records say 5 or 6 records while it is showing all the records say 10,000+ records in the Unidata database. I must admit that there is one column in this table. While running the job data is not getting uploaded. This is the same case with all the tables which are having one column. Here column is ID and it is primary key.
How to resolve this ?
Regards,
Vaibhav Malhotra,
Software Engineer
Noida,India
Software Engineer
Noida,India
Vaibhav,
Immediate help costs money, this is a volunteer site. If you have a contract with Ascential or a service provider you might get help there.
Your problem description was vague, which is probably why you haven't gotten a response. And since you specified "urgent" it reminded me that I need to go home.
If you were to attempt debugging your problem a bit more and specifying exactly what isn't working as expected you might get an answer.
Immediate help costs money, this is a volunteer site. If you have a contract with Ascential or a service provider you might get help there.
Your problem description was vague, which is probably why you haven't gotten a response. And since you specified "urgent" it reminded me that I need to go home.
If you were to attempt debugging your problem a bit more and specifying exactly what isn't working as expected you might get an answer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi ,
When I try to view data in unidata stage ,I am able to view only 10 records.
Whereas in unidata there are 4060 records in this table.
Any suggestion as to why am not able to view other records ???
Further this table has only one column that too ID and its is not multi valued .
Ray - I am using ID in the unidata stage .
Regards,
When I try to view data in unidata stage ,I am able to view only 10 records.
Whereas in unidata there are 4060 records in this table.
Any suggestion as to why am not able to view other records ???
Further this table has only one column that too ID and its is not multi valued .
Ray - I am using ID in the unidata stage .
Regards,
Vaibhav Malhotra,
Software Engineer
Noida,India
Software Engineer
Noida,India
I you write your job to read the data and write it straight to a sequential file with no modifications or other stages, does it do more than the 10 records you see in "view data"? Are there any warnings or errors in the log file for that run?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi Arnd,
Unidata is my repository db.
I need to extract data from here and migrate it to oracle db .
In the first stage itself....i.e unidata stage : I am able to view only 10 records ....whereas the table contains 4060 records.
I ma unable to understand as to why I am not able to view further records.
This is not a multivalued column .
Further I am not getting any warning messages too.
Regards,
Unidata is my repository db.
I need to extract data from here and migrate it to oracle db .
In the first stage itself....i.e unidata stage : I am able to view only 10 records ....whereas the table contains 4060 records.
I ma unable to understand as to why I am not able to view further records.
This is not a multivalued column .
Further I am not getting any warning messages too.
Regards,
Vaibhav Malhotra,
Software Engineer
Noida,India
Software Engineer
Noida,India
Please, I understood your question the first 2 times.
Sometimes "View Data" works differently than when you run a job. Right now you are stating that when you view data in the job designer you only get 10 rows. I am asking that you write your data to a sequential file and RUN the job to see if it still shows only 10 records. If not, the issue is within the designer's view data, if not then we can look elsewhere.
Also, did you perhaps specify a "selection" in that tab?
Sometimes "View Data" works differently than when you run a job. Right now you are stating that when you view data in the job designer you only get 10 rows. I am asking that you write your data to a sequential file and RUN the job to see if it still shows only 10 records. If not, the issue is within the designer's view data, if not then we can look elsewhere.
Also, did you perhaps specify a "selection" in that tab?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
1. Please check to make sure that you are not doing a SELECT in your unidata stage
2. Can you connect to unidata and do a COUNT on that file? Also list the whole file to make sure that it is not broken.
3. Can you select & view another file completely - i.e. is this limited to the one file or to some or all files?
4. Are the 10 keys you do see different or "special" compared to the rest of the file?
5. (should be at position 2). Add BY clause to change your result order. Do you still get 10 and are they a different 10?
2. Can you connect to unidata and do a COUNT on that file? Also list the whole file to make sure that it is not broken.
3. Can you select & view another file completely - i.e. is this limited to the one file or to some or all files?
4. Are the 10 keys you do see different or "special" compared to the rest of the file?
5. (should be at position 2). Add BY clause to change your result order. Do you still get 10 and are they a different 10?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi
Answer to point 1-
I am not doing select in unidata stage.
Answer to point 2-
Connecting unidata through REFLECTION.
The count from unidata db is 4060 .
( select count(*) from table_name )
If I do select * from tablename i am able to view data .
Answer to point 3-
There is no problem with other tables.
Answer to question 4--
10 keys are like this :
1898
5101
201
4904
7071
2057
Thre are no special characters.
Answer to question no 5-
Position is 0
Regards,
Answer to point 1-
I am not doing select in unidata stage.
Answer to point 2-
Connecting unidata through REFLECTION.
The count from unidata db is 4060 .
( select count(*) from table_name )
If I do select * from tablename i am able to view data .
Answer to point 3-
There is no problem with other tables.
Answer to question 4--
10 keys are like this :
1898
5101
201
4904
7071
2057
Thre are no special characters.
Answer to question no 5-
Position is 0
Regards,
Vaibhav Malhotra,
Software Engineer
Noida,India
Software Engineer
Noida,India
By (5) I didn't mean a position in the columns, but just the order to test. Can you add a sort and see if you get the same keys in the same order, the 10 original keys sorted, or 10 ascending keys not in your original list.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>