Answer Posted / ramesh

the main difference between connected and unconnected is

connected:
recieves data from source table in a pipeline.
it returns multiple columns
it supports user defined default values
unconnected:
recieves data from result of the lookup expresion on other transformation
it returns one column
it doesnt supports use defined default values

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4060

---

Tell me about Propagate functions in informatica

870

---

is it possible to index the data in cache of lkp transformation ?

1956

---

How many input parameters can exist in an unconnected lookup?

1488

---

What do you mean by blocking transformation?

966

---

What are the differences between source qualifier and joiner transformation?

992

---

Define mapplet?

959

---

Explain the difference between a data warehouse and a data mart?

999

---

What do you understand by SOA of Informatica?

921

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1967

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1584

---

What is an Integration service in Informatica?

1078

---

Write the advantages of partitioning a session?

1199

---

What is an aggregator transformation?

1025

---