Answer Posted / naganji mandru
Using aggrgator one way,Another way write query from database stage like
Select deptno,count(*) as c from emp group by deptno
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
in oracle target stage when we use load option and when we use upsert option?
sed,awk,head
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between the local container and shared container?
Where do the datastage jobs get stored?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is meta 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.
Explain ibm infosphere information server and highlight its main features?
Explain the importance of surrogate key in data warehousing?
In Datastage, how you can fix the truncated data error?
What could be a data source system?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How do you import and export data into datastage?
What are the repository tables in datastage?
