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?
Answers were Sorted based on User's Feedback
Answer / pakkya
implement scd type1 -
simply overwrite with new data
implement scd type2 -
use merge stage to do an inner join on all columns after
sorting data, rows that do not join from merge result are
your changes
remove ',' - use Trim function with A option that removes
all occurences of ','
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
how do u reduce warnings
What are the enhancements made in datastage 7.5 compare with 7.0?
what is ds administrator used for?
What are sequencers?
Name the different sorting methods in datastage.
What is the difference between passive stage and active stage?
what is initial load and incremental load
How can we achive parallelism
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
How do you run datastage job from the command line?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
What are the primary usages of datastage tool?