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 usage of datastage with materialized views
How do you load dimension data and fact data? Which is first
what is the use of surogate key in datastage
Highlight the main features of datastage?
How to move data set from one server to other?what are the steps to follow to do this?
wt is the diff b/w odbc and oracle stage
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
what r the sources u need to create the datastage?
Where do the datastage jobs get stored?
Why we use parameters instead of hard code in datastage.
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
What steps should be taken to improve Datastage jobs?