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
- 14188 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
Highlight the main features of datastage?
What are stage variables, derivations and constants?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the various kinds of containers available in datastage?
How do you import and export the datastage jobs?
Can you highlight the main features of ibm infosphere information server?
How you can fix the truncated data error in datastage?
How to perform incremental load in datastage?
Is the value of staging variable stored temporarily or permanently?
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?
Which warehouse using in your datawarehouse
How to Remove Duplicate using SQL?
What is the precedence of stage variables,derivations, and constraints?
