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
- 6819 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 |
What are some prerequisites for datastage?
Difference between data warehousing and olap?
what is the difference between == and eq in UNIX shell scripting?
what is the use of surogate key in datastage
What is the flow of loading data into fact & dimensional tables?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how do u capture duplicates through sort & transformer
what is the diff between sequential file and fileset stages?
Why do you need stage variables?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
what is executable in DataStage?
Teradata 
