Answer Posted / moorthy g

Hi Jey,

Please see the below procedures (integer to varchar or char).
SQL> CREATE TABLE DEPT1 AS SELECT *FROM DEPT
SQL> Truncate table dept1;
SQL> alter table dept1 modify(deptno varchar2(20));
SQL>insert into dept1 select *from dept;
SQL> SELECT *FROM DEPT1

Note:
1. If you want to modify in information please the load type
truncate load or not. (May it will be truncate load only)

Best Regards,
Moorthy. G

What are the restrictions of union transformation?

572

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7666

---

Difference between Target-based loading and constraint-based loading?

548

---

What is pmcmd command?

668

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

889

---

---

Explain the types of transformations?

591

---

How might one distinguish in the case of mapping is right or not without associating session?

636

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744

---

tell me about your project functionality

1859

---

What are the tasks that source qualifier perform?

627

---

What is a sorter transformation?

652

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1615

---

What does refresh system mean, and what are its distinctive choice?

564

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1624

---

Write the program through which the records can be updated?

507

---