Answer Posted / prince
Hi Venu, The definition you said for Fastly Changing Dimensions is true, but can you give one more example of a entity that changes frequently. Because ATM transactions will be loaded into FACT TABLE as that is a TRANSACTIONAL DATA but it is not loaded to DIMENSION TABLE.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Name the different sorting methods in datastage.
What is the difference between orabulk and bcp stages?
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
what is the difference between == and eq in UNIX shell scripting?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what are the errors,warnings in datastage
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the repository tables in datastage?
What is "fatal error/rdbms code 3996" error?
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.
How to implement complex jobs in data stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Explain ibm infosphere information server and highlight its main features?
What are the types of jobs we have in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...