1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 13394 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
Answer Posted / kumar
By using distinct we can eliminate duplicates,
by using variable comparison we can eliminate duplicates.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some prerequisites for datastage?
How do u convert the columns to rows in datastage?
What are the partitioning techniques available in link partitioner?
Define repository tables in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explain usage analysis in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Is the value of staging variable stored temporarily or permanently?
Explain connectivity between datastage with datasources?
What are the functionalities of link partitioner?
How do you reject records in a transformer?
Why do we use link partitioner and link collector in datastage?
What is the purpose of pivot stage and types of containers in datastage
Name the third party tools that can be used in datastage?
How do you register plug-ins?
