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
- 6459 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 |
source file is having 5 records while moving into target it want to be 10 records
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
How we can covert server job to a parallel job?
How do you reject records in a transformer?
Define repository tables in datastage?
How the ipc stage work?
What is process model?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What could be a data source system?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
in aggregator , how can i get the sum in readable format
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Teradata 
