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 |
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?
How a source file is populated?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is the precedence of stage variables,derivations, and constraints?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
What are the prerequisites for join stage
Explain the scenarios where sequential file stage runs in parallel?
how to find diff between 2 dates without using Icon... funtions?
How to RD using transformer?
What is mapping?