It's all about the answers!

Ask a question

Time of creating Fact build getting error target table column is missing


pravin gaykar (4232225) | asked Apr 25 '14, 6:07 a.m.
getting error Target table check
Inconsistencies found in the following tables:
   Connection 'JAZZDWH'
          Table '"RIODS"."PROJECT"'
                    Column '"TS_TEST_VERSION"' missing

Accepted answer


permanent link
Francesco Chiossi (5.7k11119) | answered Apr 25 '14, 7:14 a.m.
Hello Pravin,

I'm not familiar with the article you mention, but from a first look it only leverages the existing fields in the RIODS.PROJECT table.
You can add any column you like to the table, using your DBMS commands, but you need to understand that if you want to see the additional columns in your report you will need a customization of the Framework Manager data model as well. That is not covered by the article.

Best Regards,

Francesco Chiossi
pravin gaykar selected this answer as the correct answer

Comments
pravin gaykar commented Apr 28 '14, 8:36 a.m.

Hello Francesco, 

Thanks for earlier...
I have tried to find out how to add column in table using frame work manager but not yet get solution.  Can you help me to add coulmn in RIODS table or datawarehouse table.


Francesco Chiossi commented May 01 '14, 5:29 a.m.

Hello Pravin,

An high level description of Data warehouse customization is available in this section of the Insight Info Center:

Customizing the data warehouse
http://pic.dhe.ibm.com/infocenter/rentrpt/v1r1m1/topic/com.ibm.rational.raer.help.doc/topics/t_modifyingdatamartsusingrda.html

It also has an "Adding columns to a table" topic.

Best Regards,

Francesco Chiossi


pravin gaykar commented May 09 '14, 9:02 a.m.

article which you have given is ctreation column using diff. tool Info sphere data architect. Can you help to create column in dataware house DB itself using frame work manager or insight dev tools?


Francesco Chiossi commented May 09 '14, 9:06 a.m.

Hello Pravin,

I don't think you can do it from framework manager or data manager alone.
The alternative to Info sphere data architect would be using you DBMS administrative tools or SQL clients.

Best Regards,

Francesco Chiossi


pravin gaykar commented May 13 '14, 3:40 a.m.

Hi Francesco,

Using below article we are able to pull HPQC data into Dataware house.

https://jazz.net/library/article/1352

Now we want generate report using query studio or report studio.

Can you help on same?

Thanks,

Pravin

One other answer



permanent link
Francesco Chiossi (5.7k11119) | answered Apr 25 '14, 6:17 a.m.
Hello Pravin,

TS_TEST_VERSION is not a column of the RIODS.PROJECT table.

Could you please clarify what exactly you were doing when you got the error message?
Are you doing any customization?

Best Regards,

Francesco Chiossi

Comments
pravin gaykar commented Apr 25 '14, 6:29 a.m.

Thanks for earlier, I am pulling data from HPQC to Insight DW. I am refering below article for same https://jazz.net/library/article/1352 In Project table delivery properties In table name fileld I have selected RIODS table is Project. How I can add TS_TEST_VERSION column in RIODS.PROJECT table?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.