Answer Posted / millar

ie.

select column from table_name where mod(primary_key_column,2)=1;


select employee_id from employees where mod(employee_id,2)=1

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

1964

---

What is deployment group?

1218

---

Which is the t/r that builts only single cache memory?

1190

---

What are the transformations that are not supported in mapplet?

1033

---

what is the size of u r source(like file or table)?

2272

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

---

How do you convert single row from source into three rows into target?

1158

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2306

---

Differentiate between source qualifier and filter transformation?

1584

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2425

---

What is mapplet in informatica?

1060

---

Explain the etl program with few examples.

1054

---

Enlist the advantages of informatica.

1068

---

Can you use flat files in Mapplets.

2653

---

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

1070

---