Answer / swetha

Master and detail source

Type of join

Condition of the join

Answer / raja

join condition


type of join
master and detail source

increase or decrease the cache sizes

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

How to load a relational source into file taget?

2 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

Define error Threshold?

1 Answers  

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

What are two types of processes that informatica runs the session?

2 Answers  

---

What is polling?

1 Answers  

---

Informatica and datawarehousing courses in Pune?

2 Answers  

---