Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 15338 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan
To remove duplicates we could use Remove Duplicates Stage.
If the requirement states not to use a remove duplicates
stage, u culd use Sort stage, by setting one of its
property Allow Duplicates to false.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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 some different alternative commands associated with "dsjob"?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Differentiate between hash file and sequential file?
Is it possible to query a hash file?
Difference between data warehousing and olap?
Differentiate between data file and descriptor file?
what is flow of project?
what is ds administrator used for?
Differentiate between validated and Compiled in the Datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
What is a merge in datastage?
What are the main features of datastage?
How a source file is populated?
What is the importance of the exception activity in datastage?
