By using the sort stage we can remove the duplicates by setting the option

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?chandu
how can i implement scd typ1 and type2 in both server and in parallel?chandu
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the ,inthe fields?

Question Posted / murari

2 Answers
6821 Views
I also Faced
E-Mail Answers

Answer Posted / murari

By using the sort stage we can remove the duplicates by setting the option ALLOW DUPLICATES=FALSE......

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is flow of project?

1938

What are the different types of lookups in datastage?

1006

Distinguish between informatica & datastage. Which one would you choose and why?

954

How to convert RGB Value to Hexadecimal values in datastage?

3929

What is the use of datastage director?

975

Have you used Unstructured data?

1269

Name the command line functions to import and export the DS jobs?

1091

Define data aggregation?

1048

Have you have ever worked in unix environment and why it is useful in datastage?

1084

why do u need the IOS upgradation in a FC switch

2225

What is the different type of jobs in datastage?

902

Is the value of staging variable stored temporarily or permanently?

933

Explain ibm infosphere information server and highlight its main features?

1036

What are the stages in datastage?

1032

How can one find bugs in job sequence?

1319