Give example for FACTLESS FACT TABLE in real-time scenario.
Answer Posted / ram
for ex:%discount in retail project
studant Attendance
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
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.
What are the types of containers and how to create them?
How to read multiple files using a single datastage job if files have the same metadata?
Where the datastage stored his repository?
How do you run datastage job from the command line?
what is the use of materialized view?
Explain connectivity between datastage with datasources?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Explain Quality stage?
Can you explain link buffering?
Define Merge?
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
Explain how a source file is populated?
How to implement complex jobs in data stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?