Interested to Buy Any Domain ? << Click Here >> for more details...
souce file having the columns like
name company
krish IBM
pooja TCS
nandini WIPRO
krish IBM
pooja TCS
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
- 9 Answers
- 12195 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
use aggregator stage take count(*) group by name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Triggers,VIEW,Procedures
What is a merge in datastage?
Which commands are used to import and export the datastage jobs?
EXPLAIN SCD
What are the types of views in datastage director?
Which warehouse using in your datawarehouse
Differentiate between Join, Merge and Lookup stage?
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.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do y read Sequential file from job control?
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 are the different layers in the information server architecture?
Difference between in process and inter process?
Is the value of staging variable stored temporarily or permanently?
what is the use of surogate key in datastage
