Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 16514 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
Use Transformer Stage:
Take two stage variable
sv1= if sv2=DEPT_NO then sv1 : ' ' : EMPNAME
sv2= DEPT_NO
Derivation : Trim(sv1, ' ','L')
U will get output.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Describe the architecture of datastage?
What is the difference between the local container and shared container?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the important features of datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to implement scd2 in datastage 7.5 with lookup stage
How do you import and export data into datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you generate sequence number in datastage?
Differentiate between Join, Merge and Lookup stage?
How you Implemented SCD Type 1 & Type 2 in your project?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Define meta stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the main features of datastage?
