it is possible to load two tables data into one sequential file?if possible how?plz share with me?
TCS,
6 10650i 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 10321i 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 8273i 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 5947Hi 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
2343
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Why fact table is in normal form?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the difference between odbc and drs stage?
What is difference between join, merge and lookup stage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the precedence of stage variables,derivations, and constraints?
How many types of views are there in a datastage director?
What are the types of containers and how to create them?
How the ipc stage work?
What is the roundrobin collector?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How can we improve performance of data stage jobs?
What are the functionalities of link partitioner?
How to find value from a column in a dataset?