How to Remove Duplicate using SQL?
No Answer is Posted For this Question
Be the First to Post Answer
How complex jobs are implemented in datstage to improve performance?
Why we use parameters instead of hard code in datastage.
What is job control?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
whats difference between ls -ltr and ls -lrt?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
i have flat file and using unix how can i generate sequence number into targer?
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
What is use Array size in datastage
what is mapping lookup
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.
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?