Converting Vertical PIVOTing without using PIVOT stage in DataStage.
Ex:
DEPT_NO EMPNAME
10 Subhash
10 Suresh
10 sravs
Output:
DEPT_NO EMP1 EMP2 EMP3
10 subhash suresh sravs
2) How to implement Horizontal PIVOTing without using PIVOT stage.
Answer Posted / reddymkl.dwh
Use Transformer Stage:
Take stage variable,
sv1 = sv1 : ' ' : DSLink.EMPNAME
Derivation : Trim(sv1, ' ','L')
U will get output.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the different kinds of views available in a datastage director?
What is the difference between passive stage and active stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is the difference between == and eq in UNIX shell scripting?
What could be a data source system?
What is difference between symmetric multiprocessing and massive parallel processing?
Why fact table is in normal form?
Differentiate between operational datastage (ods) and data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Describe stream connector?
What is the difference between operational data stage (ods) and data warehouse?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is a datastage job?
What is the process of killing a job in datastage?