1)What is ur project architecture ?
2)how to move project from developement to uat?
3)What is the difference between datastage 6,7.1 and
datasttage 7.5?
4).How to do error handling in datastage?
5)3.Whta is unit testing, system testing and integration
testing?
6)What is the Exact difference between BASIC Transformer
and NORMAL Transformer?When we will go for BASIC Or NORMAL
Transformer
7)why we use third party tools in datastage?
8)What is the purpose of Debugging stages? In real time
Where we will use?
Answer Posted / rajesh
1) bottom up architecture
2)Through ds manager export into local machine from development server in .dsx format and then import into uat server.
4) go to status view in datastage director. we can see errors.
6)Basic transformer:- Compiles in Basic language and takes less time to compile.
Doesn't supports multiple nodes and use in server jobs.
Normal transformer:- compiles in basic language and c++ and takes more time to compile compare to basic transformer.
It is used in parallel jobs and supports nodes.
7)More reliable to support particular process like sheduling ann ata modelling.
eg- autosis, erwin
8) to pick up sample data and to test d job.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the main features of datastage?
Name the different sorting methods in datastage.
Differentiate between data file and descriptor file?
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.
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
I have a few records just I want to store data in to targets cycling way how?
Define ds designer?
Can you implement SCD2 using join, transformer and funnel stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Define orabulk and bcp stages?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
State the difference between an operational datastage and a data warehouse?
How rejected rows are managed in datastage?
Triggers,VIEW,Procedures
how to sort two columns in single job in datastage.