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 6480i 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 7534Anyone 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 11174Hi 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 17023my 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 9502souce 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 12300How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
3 9439guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
TCS,
2 7793
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the purpose of pivot stage?
What are the some differences between 7.x and 8.x version of datastage?
Name the different sorting methods in datastage.
What are routines in datastage? Enlist various types of routines.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is aggtorec restructure operator?
What is quality stage?
What are the difference types of stages?
How you can fix the truncated data error in datastage?
what is the use of materialized view?
What are the job parameters?
What is size of a transaction and an array means in a datastage?
whom do you report?