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?
how can i implement scd typ1 and type2 in both server and
in parallel?
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the duplicate rows,inthe fields?
- 0 Answers
- 1741 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is PX?
How complex jobs are implemented in datstage to improve performance?
how many types of sorting the data in data stage?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
how do u reduce warnings
Explain the scenarios where sequential file stage runs in parallel?
How do you load 10 different sources with 10 different layouts to 10 different tables?
Is possible to create skid in dim,fact tables?
Explain the situation where you have applied SCD in your project?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Can you explain repository tables in datastage?
What are the functionalities of link collector?
Teradata 
