I/P
---
ID Value
1 AB
2 ABC
3 ADE
4 A
O/p
---
ID Value
1 A
1 B
2 A
2 B
2 C
3 A
3 D
3 E
4 A
- 3 Answers
- 6274 Views
- IBM, I also Faced
- E-Mail Answers
Post New Answer View All Answers
Enlist various types of routines in datastage.
What is size of a transaction and an array means in a datastage?
how to delete one row in target dataset
What are the different common services in datastage?
How to reverse the string using SQL?
Demonstrate experience in maintaining quality process standards?
How to RD using transformer?
How a routine is called in datastage job?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Can you implement SCD2 using join, transformer and funnel stage?
Describe link sort?
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
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.
What are the main features of datastage?
What all the types of jobs you developed?
