Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14378 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
What is the use of hoursfromtime() function in transformer stage in datastage?
Is it possible to query a hash file?
Describe the architecture of datastage?
Explain the importance of surrogate key in data warehousing?
What are the components of datastage?
Can you define merge?
Describe link sort?
Describe routines in datastage? Enlist various types of routines.
Have you used Unstructured data?
What is difference between join, merge and lookup stage?
What are the various kinds of containers available in datastage?
Differentiate between Join, Merge and Lookup stage?
What are the repository tables in datastage?
What are the different common services in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
