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 / 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 |
Post New Answer View All Answers
What are iconv and oconv?
What is oci?
root tree will find which is server job and which is parallel job?
What is quality stage?
Difference between data warehousing and olap?
Define project in datastage?
Describe routines in datastage? Enlist various types of routines.
What is a folder? Difference types of stages?
Why do we use exception activity in Datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the difference between validated and compiled in the datastage?
On which interface you will be working as a developer?
AGGREGATOR default datatype
what is the use of materialized view?
what is the custome stage in datastage? how can we impliment that one? plz tell me