how can we create tables in datastage?
- 1 Answers
- 12359 Views
- I also Faced
- E-Mail Answers
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 |
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
How many Key we can define in remove duplicate stage?
what is use of SDR function?
Have you have ever worked in unix environment and why it is useful in datastage?
How you can fix the truncated data error in datastage?
What are stage variables, derivations and constants?
wt is the difference between swith and filter stage
how to abort the job its matain duplicates?
What is container and then types?
What is the difference between orabulk and bcp stages?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
What is a range lookup?
Teradata 
