Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6854 Views
- I also Faced
- E-Mail Answers
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 |
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Which warehouse using in your datawarehouse
How many types of sorting methods are available in datastage?
What are the different options associated with dsjob command?
What are the differences between datastage and informatica?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
why do u need the IOS upgradation in a FC switch
HOW CAN WE SEE THE DATA IN DATASET?
What are the steps required to kill the job in Datastage?
Why do we use exception activity in Datastage?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
Teradata 
