how can we create tables in datastage?
Answer / hanug
The DB tables will be created in two ways
1. By right clicking on on the navigator on any of the
folder, you can choose NEW -> Table definition
2. We can also create new table using Database stages.
| Is This Answer Correct ? | 2 Yes | 8 No |
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
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
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)
how will u design file watch jobs?
How to Remove Duplicate using SQL?
What is the purpose of pivot stage and types of containers in datastage
What are data elements?
which memory is used by lookup and join
How did you reconcile source with target?
what is sparse lookup?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
Differentiate between validated and Compiled in the Datastage?