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
- 16736 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
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
Triggers,VIEW,Procedures
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How and where you used hash file?
How to implement complex jobs in data stage?
Can you filter data in hashed file?
What is the difference between operational data stage (ods) and data warehouse?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the roundrobin collector?
Differentiate between operational datastage (ods) and data warehouse?
What is the difference between Datastage 7.5 and 7.0?
What are the different types of lookups in datastage?
Can you explain tagbatch restructure operator?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Can you explain kafka connector?
Define orabulk and bcp stages?
