In my previous project we get data from mainframe and load it
into datastage DB2 tables.Sometimes we get data as flat file
or a mainframe tables itself directly we fetch the data.Is
this a migration project?
Answer / sarath
We can not say this is/isnt a migration project based on your query.For many projects we get the data from mainframe or as flat file
Migration project means the entire code is developed in one technology ( lets say eg: SAS) and now they want to implement the same code in new technology ( say now DATASTAGE) for better performance. as it will take more time to complete the job in SAS compared to datastage. finally the goal is optimization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
ename like ibm,tcs,hcl need display those records only how?
Give example for FACTLESS FACT TABLE in real-time scenario.
Where the datastage stored his repository?
what is the Difference Between Datastage Server Edition and Parallel Edition?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
source file contains 100 records, i want 10 records in target file how it possible in datastage
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
What is the difference between lookup and sparse lookup?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What are the third party tools you used in your project?