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,
2133Hi, 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 127601.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 14865i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
1 5926
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the types of hashed files in data stage
How to read multiple files using a single datastage job if files have the same metadata?
What are the some differences between 7.x and 8.x version of datastage?
What is the precedence of stage variables,derivations, and constraints?
what is use of SDR function?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How can you write parallel routines in datastage PX?
What are the benefits of datastage?
How the ipc stage work?
how to implement scd2 in datastage 7.5 with lookup stage
Where do the datastage jobs get stored?
Nls stands for what in datastage?
What are the different options associated with dsjob command?
Differentiate between odbc and drs stage?