1)what is the size of Fact table and dimension table?
2)how to find the size of Fact table and dimension table?
3)how to implement the surrogate key in transform stage?
4)write the configuration file path?
5)how many types of datasets explain?
6)diff b/w developed projects and migration projects?
7)how to delete the header and footer file of the sequencer
file?
8)how can u call the parameters in DS in unix environment?
9) how much data ur getting daily ?
10)
No Answer is Posted For this Question
Be the First to Post Answer
Define APT_CONFIG in Datastage?
what is the exact difference between dataset and fileset in datastage?
Differentiate between validated and Compiled in the Datastage?
What are stage variables and constants?
Enlist various types of routines in datastage.
How can you find out whether datastage process is running or not in unix?
What is size of a transaction and an array means in a datastage?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
how to do pergformence tuning in datastage?
What are transforms and what is the differenece between routines and transforms?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers