it is possible to load two tables data into one sequential file?if possible how?plz share with me?
TCS,
6 10634i 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 10274i 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 8242i 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 5929Hi 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
2338
How you Implemented SCD Type 1 & Type 2 in your project?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Where the datastage stored his repository?
What is a ds designer?
Can you explain engine tier in information server?
What is the difference between account and directory options ?
in oracle target stage when we use load option and when we use upsert option?
What is the roundrobin collector?
Name the different types of Lookups in Datastage?
Differentiate between validated and Compiled in the Datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between Datastage 7.5 and 7.0?
What is the difference between in process and inter process?
Which warehouse using in your datawarehouse
What is merge stage?