1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / sow_1


In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes ..

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

Post New Answer

More Data Stage Interview Questions

Name the third party tools that can be used in datastage?

0 Answers  

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

Differentiate between data file and descriptor file?

0 Answers  




What are constraints and derivations?

0 Answers  

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

For more Data Stage Interview Questions Click Here
Categories