Unable to migrate data from unidata to oracle

Vaibhav · Post by **Vaibhav** » Thu Dec 01, 2005 6:07 am

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,

Vaibhav · Post by **Vaibhav** » Thu Dec 01, 2005 11:06 am

Hi ,

Please help me in this reagrd , its needs to be delivered urgently.

Thanks in advance.

ArndW · Post by **ArndW** » Thu Dec 01, 2005 11:09 am

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.

ketfos · Post by **ketfos** » Thu Dec 01, 2005 11:12 am

Hi,
Did you try moving data from Unidata to a sequential file?

Ketfos

ray.wurlod · Post by **ray.wurlod** » Thu Dec 01, 2005 4:01 pm

Try creating a synonym for @ID in the UniData file dictionary, maybe called ID, and use that in the UniData stage.

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 8:27 am

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,

ArndW · Post by **ArndW** » Fri Dec 02, 2005 8:30 am

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?

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 8:37 am

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,

ArndW · Post by **ArndW** » Fri Dec 02, 2005 8:45 am

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?

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 8:55 am

Hi Arnd,

As suggested by you I used the sequential file between the unidata stage and transformer stage.

I am able to view only 10 records in sequential file (after running the job).

Please suggest .

Regards,

ArndW · Post by **ArndW** » Fri Dec 02, 2005 8:58 am

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?

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 9:17 am

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,

ArndW · Post by **ArndW** » Fri Dec 02, 2005 9:19 am

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.

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 9:51 am

Hi ,

I am not getting the same sequence by doing order by.

Reason being the ID 's sqltype is VARCHAR.

Regads,

Vaibhav · Post by **Vaibhav** » Fri Dec 02, 2005 9:54 am

Also its not in ascending order...

1
1000
1001
1002
101

Regards,