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
- 13915 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
which r the connectors used in san?
What is the difference between the local container and shared container?
Enlist various types of routines in datastage.
What is a datastage job?
What are the various kinds of containers available in datastage?
What are the stages in datastage?
What is apt_config in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is data partitioning?
What are stage variables?
What are transforms and what is the differenece between routines and transforms?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How do you import and export the datastage jobs?
how can we create rank using datastage?what is the meaning of rank?
how do u catch bad rows from OCI stage? And what CLI stands for?
