Could any one to tell Fact table Partitioning?

2 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

How do you load only null records into target?

0 Answers  

---