Answer Posted / madhusudhan reddy.d
A fact table without any facts is known as factless fact
table. Always a Fact should be a Numeric value but every
numeric value need not be a fact.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
EXPLAIN SCD
Name the different types of Lookups in Datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
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)
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain connectivity between datastage with datasources?
How can we improve performance of data stage jobs?
Define orabulk and bcp stages?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Where do the datastage jobs get stored?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the primary usages of datastage tool?
What are datastage sequences?
Describe stream connector?