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 |
What is difference between server jobs & parallel jobs?
How to perform incremental load in datastage?
when we have to go for a sequential file stage & for a dataset in datastage?
What are the partitioning techniques available in link partitioner?
Nls stands for what in datastage?
What is ibm datastage?
why dataset ?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
how to create document in datastage?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
Can you define merge?
How do y read Sequential file from job control?