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?


Answers were Sorted based on User's Feedback



if i have two tables table1 table2 1a 1..

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

if i have two tables table1 table2 1a 1..

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

Post New Answer

More Data Stage Interview Questions

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


how to write server Routine coding?

0 Answers   Eric,


What is the use of Row generator stage?

2 Answers  


If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  






pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  


How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,


how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,


i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,


How do u set a default value to a column if the column value is NULL?

7 Answers   HP,


What are the types of jobs we have in datastage?

0 Answers  


I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,


Categories