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?
IBM,
1743Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
6 109001.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 12921i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
1 5228
What are the types of containers?
What is the difference between server job and parallel jobs?
How do you register plug-ins?
What is the precedence of stage variables,derivations, and constraints?
What are transforms and what is the differenece between routines and transforms?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is data partitioning?
What is job control?
Describe the architecture of datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain usage analysis in datastage?
What are the areas of application?
What is the use of datastage director?
What is ibm datastage?
What are the primary usages of datastage tool?