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
- 15130 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
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to implement scd2 in datastage 7.5 with lookup stage
How can we improve the performance in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to sort two columns in single job in datastage.
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is aggtorec restructure operator?
What is the difference between operational data stage (ods) and data warehouse?
Can you explain players in datastage?
Define data aggregation?
Describe routines in datastage? Enlist various types of routines.
Explain the importance of surrogate key in data warehousing?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How do you register plug-ins?
