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
- 6822 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 |
specify data stage strength?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
how to convert rows into columns
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
why do we need a datawarehouse when we have databases to store data?
How many input links can you give to a Transformer stage?
Differentiate between Join, Merge and Lookup stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is exact difference between Parallel Jobs and server Jobs..
Teradata 
