Answer / murali

Add extr output port in expr trans for using sysdate
function.

Thanks,
Murali

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---

---

How can you differentiate between powercenter and power map?

0 Answers  

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

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

0 Answers   Cap Gemini,

---

What is powercenter on grid?

0 Answers  

---