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

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2061

---

Slowly changing dimensions, types and where will you use them

1656

---

Differentiate between joiner and lookup transformation?

1049

---

Separate from an archive server and a powerhouse?

908

---

What are active and passive transformations?

1022

---

What is the format of informatica objects in a repository?

976

---

How can we handle two sessions in informatica?

985

---

write a query to retrieve the latest records from the table sorted by version(scd)

1011

---

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

1092

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2183

---

Scheduling properties,whats the default (sequential)

1895

---

can we override a native sql query within informatica? How do we do it?

1054

---

How to call shell scripts from informatica?

938

---

Explain the different kinds of facts.

935

---

What is the session task and command task?

994

---