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
table actions available in oracle connector?
Explain how a source file is populated?
What are the steps required to kill the job in Datastage?
What is job control?
Can we use target hash file as a lookup ?
What is merge stage?
Can you explain repository tables in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is the method of removing duplicates, without the remove duplicate stage?
What can we do with datastage director?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How many Key we can define in remove duplicate stage?
What is use Array size in datastage
what is repositery?