what is the use of materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
Name the different sorting methods in datastage.
How do you start developing a datastage project?
where the log files or tables can store in DS?
How do you design PX Routines ?
What is a datastage job?
count number of deptno in a emp table?
root tree will find which is server job and which is parallel job?
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
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?