What is diff between Junk dimensions and conform dimension?
Answer Posted / nagireddy
a junk dimension is dimension but not using for
maping..like its a boolean value.but conform dimesion is
which dimension is shared by two or more than two fact
tables is called conform dimension.and conform dimesin
reduce the no of tables...
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Name the different types of Lookups in Datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Could anyone give brief explanation bout datastage admin
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Can you implement SCD2 using join, transformer and funnel stage?
What are the types of containers and how to create them?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the various kinds of containers available in datastage?
What is oci?
How the ipc stage work?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
what is the use of surogate key in datastage
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?
Differentiate between hash file and sequential file?
what is flow of project?