Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2742 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
What are the unit test cases you used in your project?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the various kinds of containers available in datastage?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
On which interface you will be working as a developer?
which is the most complex job in your career? Please tell me answer?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the precedence of stage variables,derivations, and constraints?
what are the types of nodes
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,
Teradata 
