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
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
Why we use surrogate key?
What is the use of hoursfromtime() function in transformer stage in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the purpose of pivot stage?
What are the important features of datastage?
What is the difference between informatica and datastage?
How do y read Sequential file from job control?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How a routine is called in datastage job?
Define APT_CONFIG in Datastage?
client know skid info?
To see hidden files in LINIX?
Describe stream connector?
Terminate Activity