Hi friends,

I am new to datastage, i have one query in datastage any one
you please give reply to my post.

I have a workbook (excel sheet) named as eg: xxxx, in that i
have two tables emp(eid, ename, salary, deptno) and
dep(deptno, name, state). in my source i have ODBC
enterprise stage read the emp table and dept table join the
two table and write the dept no
10(eid,ename,salary,name,state) values in target().

Thanks,
Badari


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,


How many number of reject links merge stage can have?

7 Answers   TCS,


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?

6 Answers   CTS, HCL, IBM, Wipro,


What is staging variable?

0 Answers  


i 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 Answers  






Unix command to view the data in a dataset

2 Answers   IBM,


What are sequencers?

0 Answers  


Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,


Can you define merge?

0 Answers  


How do you run datastage job from the command line?

0 Answers  


HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,


i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,


Categories