Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
please design job for this,
MY INPUT IS
COMPANY,LOCATION
IBM,CHENNAI
IBM,HYDRABAD
IBM,PUNE
IBM,BANGLOORE
TCS,CHENNAI
TCS,MUMBAI
TCS,BANGLOORE
WIPRO,HYDRABAD
WIPRO,CHENNAI
HSBC,PUNE
MY OUTPUT IS
COMPANY,LOCATION,COUNT
IBM,chennai,hydrabad,pune,banglore,4
TCS,chennai,mumbai,bangloore,3
WIPRO,hydrabad,chennai,2
HSBC,pune,1
Thanks
- 3 Answers
- 9060 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raj
There are two requirements here
1. Counting
2. Converting rows to columns
Here is the design of the job
Source -> Pivot(Vertical) -> Transformer -> Destination
Pivot:
1. Use vertical pivot.
2. Mention Company as Group by column and Location as pivot. In the aggregate column choose count
Transformer:
1. Above pivoting gives locations in different columns. Use transformer to concatenate these columns using : operator
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Whats difference betweeen operational data stage (ods) and data warehouse?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to add a new records into source?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the purpose of pivot stage and types of containers in datastage
what are the devoleper roles in real time? plz tell i am new to datastage....
What are routines in datastage? Enlist various types of routines.
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.
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to perform incremental load in datastage?
Define project in datastage?
What is the process of killing a job in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the difference between account and directory options ?
