Interested to Buy Any Domain ? << Click Here >> for more details...
how can we create tables in datastage?
- 1 Answers
- 12997 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 |
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
how to remove duplicates in transformer stage by using stage variables?one example?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
How many types of sorting methods are available in datastage?
What is oci?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
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?
Differentiate between odbc and drs stage?
What is the use of Row generator stage?
on how many columns we can perform aggregation in the Aggregator stage?
Teradata 
