I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 12694 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / subhash
The Simple way is:
SRCFile---->PIVOT Stage---->TGT
1. in PIVOT stage, select vertical PIVOT option.
2. specify the 'Array Size' as 2
3. select the 'Group by' check box for 'empname'
4. select the 'Pivot' check box for 'company'
then u will get the desired output.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Why fact table is in normal form?
What is the roundrobin collector?
What are the stages in datastage?
What is usage analysis in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What could be a data source system?
What is the difference between hashfile and sequential file?
Can you filter data in hashed file?
Explain datastage architecture?
How will you move hashed file from one location to another location?
Define orabulk and bcp stages?
Whats difference betweeen operational data stage (ods) and data warehouse?
sed,awk,head
Explain the datastage parallel extender (px) or enterprise edition (ee)?
