Answer Posted / sahil

We can use a query,

Select dep_id, sum(salary) from emp group by dep_id;

Here I am using group by because we might have other dep as well.

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1941

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4095

---

What is the sequence generator transformation in informatica?

1161

---

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

4132

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1074

---

without table how to come first record only in oracle?

2237

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1109

---

Explain the pipeline partition with real time example?

1124

---

Define mapplet?

998

---

What is flashback table ? Advance thanks

1922

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2730

---

What is enterprise data warehousing?

1028

---

What is option by which we can run all the sessions in a batch simultaneously?

1126

---

What are the tasks that can be performed using sq?

1078

---

Scheduling properties,whats the default (sequential)

1943

---