I have two tables joined as 1..1,1..n
but data is not getting what I am expecting....Please throw some of your exp.
Please read complete description then reply
NOTE: I CHANGED THE JOINS TO 1..n, 1..1 and 1..1,1..n so for all this I am getting different values(more or less) compared to DB(Oracle)
Two tables : A_HDR & B_DTL
Joined by using column - 123 Now what is my problem is
from A_HDR table I am selecting a Date column and from B_DTL table I am selecting a number(value) column.
In report I am able to see these values but when I go and check with the DB(oracle) I am seeing more values.
Please let me know what I need to do....
You need to check the SQL generated by Cognos and compare this with the SQL that you aim directly against Oracle. There is a pretty good chance that these statements are not directly comparable.
Other than that , your problem description is way too vague to answer properly..
You need to provide more details on the problem but from what you've said it sounds like you may need to have an outer join between the tables or set up a dummy value so that you can get all rows coming back with out the outer join.
Check the cardinality of the tables in your source.