it is possible to load two tables data into one sequential file?if possible how?plz share with me?
TCS,
6 11757i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
TCS,
7 11248i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
6 9195i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
2 6332Hi 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
2567
What are the benefits of datastage?
Demonstrate experience in maintaining quality process standards?
What is the difference between account and directory options ?
Is the value of staging variable stored temporarily or permanently?
how many rows sorted in sort stage by default in server jobs
What can we do with datastage director?
How can we improve performance of data stage jobs?
What are the different layers in the information server architecture?
How a server job can be converted to a parallel job?
What is difference between server jobs & parallel jobs?
Describe the architecture of datastage?
how to export or import the jobs in .ISX file
What is the difference between orabulk and bcp stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
Could anyone give brief explanation bout datastage admin