how to convert rows into columns
- 2 Answers
- 11007 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.
| Is This Answer Correct ? | 11 Yes | 6 No |
client know skid info?
How can you write parallel routines in datastage PX?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the steps required to kill the job in Datastage?
Explain the ChangeApply stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
What are the components of datastage?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
What are data elements?
Teradata 
