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

How do you update the records with or without using update strategy?

1164

---

Make a note of the quantity vaults made in informatica?

1046

---

What is target load order?

1302

---

In warehouses how many schemas are there?

1131

---

How to extract the informatica rejected data?

1259

---

What is the surrogate key?

1365

---

What are the main issues while working with flat files as source and as targets ?

1219

---

What is standalone command task?

1376

---

What is the difference between a connected look up and unconnected lookup?

1003

---

Differentiate between joiner and lookup transformation?

1160

---

How an expression transformation differs from aggregator transformation?

1089

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1207

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2096

---

How will the document be delivered to me?

1130

---