Answer / keerthiravi

The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

What is hash partition?

1 Answers  

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

what is runtime variable?

3 Answers   TCS,

---

What if the source is a flat-file?

0 Answers  

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

Enlist the differences between database and data warehouse.

0 Answers  

---