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 is the hint? how to use it to reduce the query processing in program?

7804

---

What is sorter transformation?

1038

---

What is Data Caches size?

1086

---

Explain how to import oracle sequence into informatica?

1005

---

What is an expression transformation?

1009

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2281

---

What is rank transformation in informatica

1169

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902

---

What is informatica?

1144

---

what is the -ve test case in your project.

2400

---

How to load a Dimension ? and how to load a fact table?

1408

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1060

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1118

---

How to extract sap data using informatica? What is abap? What are idocs?

1171

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1257

---