Answer / ash

If we select a group by port then : we get the last row of
each group based on the group by port.

If we didn't select a group by port: we get only one row
that is the last row .

Answer / chandrababu naidu

last row as output

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

What are the tasks that can be performed using sq?

0 Answers  

---

explain about lookup t/r?

1 Answers   IBM,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

What is the default source option for update stratgey transformation?

1 Answers  

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  

---

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

1 Answers   IBM,

---