Answer Posted / sakthi

i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);

2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994

---

What are the differences between a connected lookup and unconnected lookup?

1015

---

What do you mean by worklet?

1017

---

What is DR strategy for Informatica project?

1114

---

Plz can any one say me how to get the informatica certification materials and dumps

1999

---

Quickly characterize reusable change?

1058

---

In how many ways we can create ports?

1067

---

what is the difference between informatica6.1 and infomatica7.1

2182

---

What is the use of code page?

1010

---

Explain the tuning lookup transformation - informatica

951

---

Why sorter is an active transformation?

1130

---

Explain pmcmd command usage in informatica

1065

---

What is the session task and command task?

991

---

What do mean by local and global repository?

1151

---

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

4068

---