Give example for FACTLESS FACT TABLE in real-time scenario.

Answer Posted / viswa

Factless table means only the key available in the Fact
there is no measures available.

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference types of stages?

625


in oracle target stage when we use load option and when we use upsert option?

1759


How to read multiple files using a single datastage job if files have the same metadata?

744


How rejected rows are managed in datastage?

927


Can you filter data in hashed file?

3353






Explain ibm infosphere information server and highlight its main features?

615


Describe the architecture of datastage?

574


AGGREGATOR default datatype

938


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2738


Notification Activity

903


How to reverse the string using unix?

2815


What is the flow of loading data into fact & dimensional tables?

600


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2434


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2749


What are the stages in datastage?

641