Records in ODS
We have two ODS A and B and we want to combine these two ODS's and into C
for example in ODS A we have following fields
1 2 3 4 5
and in ODS B we have following fields
6 2 7 8 9
i am expecting to have a view in my C ods like this when i combine both
1 2 3 4 5 6 7 8 9
but i am getting it as
1 2 3 4 5 in one row and the rest in the second row
the key fields in my C ods are
1 2 6 7
that is 1 2 from A and 67 from B. so can somebody guide me how to achieve this into
one record. without having in two records.
thanks and regards
basically we need one or more field that exist in both ods A and B that can be used for matching, then when populate C ods from A or B ods (e.g from A ods), we then look up some keyfigures value from B using the matching field.
hope this helps.