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 |
What is a range lookup?
Explain Quality stage?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
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?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
What a datastage macro?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
I have 100 records how can I load at a time from the single time
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
How do y read Sequential file from job control?