i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
ABC,
1 5608i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
2 6590Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
IBM,
2 9712Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
IBM,
2 15678my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
TCS,
3 8252souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
9 10010How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
3 8028guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
TCS,
2 6548
What are some different alternative commands associated with "dsjob"?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Whats difference betweeen operational data stage (ods) and data warehouse?
How do you import and export data into datastage?
What are the types of hashed files in data stage
What are the functionalities of link collector?
How do u convert the columns to rows in datastage?
How do you register plug-ins?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Highlight the main features of datastage?
What are the different type of jobs in datastage?
What is the difference between datastage and datastage tx?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Name the different sorting methods in datastage.
Demonstrate experience in maintaining quality process standards?