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?
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
On which Dimension Table you implemented SCD Type in your Project
What is the importance of the exception activity in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Notification Activity
How do you remove duplicate values in datastage?
whom do you report?
What is ibm datastage?
How a source file is populated?
in oracle target stage when we use load option and when we use upsert option?
What are the functionalities of link partitioner and link collector?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to export or import the jobs in .ISX file
How do you schedule or monitoring the job?
Is possible to create skid in dim,fact tables?
What are the job parameters?