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
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
i have a scenario in which i/p columns areID,salary with
1,1000 2,2000 and 3,3000 i need an extra column in the o/p
named avg(salary)how can i get it?
Answer
Is This Answer Correct ? | 2 Yes | 1 No |
whats relation between configuration file and datasets?
Answer
Is This Answer Correct ? | 5 Yes | 0 No |
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
Answer
Is This Answer Correct ? | 8 Yes | 2 No |
Question { Cap Gemini, 12029 }
file1
1
2
3
4
file2
3
4
5
6
output should be in three targets
T1 T2 T3
1 3 5
2 4 6
how to do this? can any one help?
Thanks
Answer
Is This Answer Correct ? | 24 Yes | 1 No |
My source having following data as below,
AB1
Aim2
Abnv5
1An8bx
and my question is i need the Datastage job the following
as in my target
000AB1
00Aim2
0Abnv5
1An8bx
Please help me to achive this.
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { SLK Software, 12110 }
i have input like this
Column 1 ,column 2
3,a
4,b
5.c
i want outputĀ
aaa
bbbb
ccccc
Ple help any one?
Answer
Is This Answer Correct ? | 3 Yes | 0 No |
in datastage interview qustion
source target
------- -------
12345 1
2
3
4
5
Answer
Is This Answer Correct ? | 2 Yes | 1 No |