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
- 9100 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhash
what Ankit explained is correct. but small correction:
as per abouve explanation we get o/p location as below:
LOCATION
,chennai,hydrabad,pune,banglore
,chennai,mumbai,bangloore
,hydrabad,chennai
,pune
So, we need to do LTRIM/TRIM Function in devivation of the
column:
TRIM(temp1,',')---------->Location
then we get desired output.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
in oracle target stage when we use load option and when we use upsert option?
What are the stages in datastage?
What is the difference between datastage and datastage tx?
Distinguish between informatica & datastage. Which one would you choose and why?
What a datastage macro?
Why do we use exception activity in Datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is meta stage?
why do u need the IOS upgradation in a FC switch
What is difference between symmetric multiprocessing and massive parallel processing?
Is the value of staging variable stored temporarily or permanently?
what are the errors,warnings in datastage
How will you move hashed file from one location to another location?
What is usage analysis in datastage?
