Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 10108 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
SRC-aggregator-tgt
In the aggregator take the avg
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Could anyone give brief explanation bout datastage admin
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Explain the importance of surrogate key in data warehousing?
What is the difference between odbc and drs stage?
Explain entity, attribute and relationship in datastage?
what is ds administrator used for?
Explain connectivity between datastage with datasources?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How to convert RGB Value to Hexadecimal values in datastage?
What are some prerequisites for datastage?
What is the differentiate between data file and descriptor file?
explain about citrix scheduling tool in datastage
What are the types of containers and how to create them?
