there are indexes on a table as
index1 with col1, col2
index2 with col2
index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
What is container and then types?
What are the types of containers and how to create them?
How do u view log file for a particular job?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
what is Audit table?Have u use audit table in ur project?
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
what is the difference between datasatge and datastage TX?
What is difference between join, merge and lookup stage?
What are the various kinds of the hash file?
How one source columns or rows to be loaded in to two different tables?