In my source i have 10 records but i want 11 records in
target. How can i acheive this in Server jobs.
Answers were Sorted based on User's Feedback
Answer / satyam
using pivot satage you can get that target records dont bother ok you have to implement that ,otherwise transformer stage in also you can add one record in output colomns and implement thatderivation cell . ok i think it very useful to tour question
| Is This Answer Correct ? | 4 Yes | 4 No |
in oracle target stage when we use load option and when we use upsert option?
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?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to implement complex jobs in data stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how does work server jobs?
source file contains 100 records, i want 10 records in target file how it possible in datastage
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
How to clean the datastage repository?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
What is Cleanup Resources and when do you use it?
What is the method of removing duplicates, without the remove duplicate stage?