can a fact table contains textual information
- 6 Answers
- 11779 Views
- HCL, HCL BSERV, IBM, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
NO.As a Fact table, it contains foreign keys for maintaining
relationships and measures for analyzing the business as
year/half-year/quarter wise.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are stage variables, derivations and constants?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
in oracle target stage when we use load option and when we use upsert option?
What is the difference between server job and parallel jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How to find value from a column in a dataset?
Is the value of staging variable stored temporarily or permanently?
How do you generate sequence number in datastage?
Define APT_CONFIG in Datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Define Job control?
If you want to use a same piece of code in different jobs, how will you achieve this?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
client know skid info?
