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
- 12551 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
EXPLAIN SCD
What is the method of removing duplicates, without the remove duplicate stage?
Explain Quality stage?
What steps should be taken to improve Datastage jobs?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Which warehouse using in your datawarehouse
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are routines in datastage? Enlist various types of routines.
Where do the datastage jobs get stored?
Can you implement SCD2 using join, transformer and funnel stage?
Enlist various types of routines in datastage.
Why we use surrogate key?
which r the connectors used in san?
Define APT_CONFIG in Datastage?
What a datastage macro?
