How to Convert the columns into rows?
Answers were Sorted based on User's Feedback
Answer / sri
Using the Pivot we can convert the columns into rows
| Is This Answer Correct ? | 20 Yes | 2 No |
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
what is the definitions for Datawarehose and Datamart?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
what is snow flack schema?
What are the functionalities of link collector?
How to remove blank spaces from data?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
What is the different type of jobs in datastage?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?