Answer Posted / moorthy g

Source --->SQ ----> Expression ---> Target

===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date

====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.

Can informatica load heterogeneous targets from heterogeneous sources?

1227

---

What is rank transformation?

1031

---

What is the difference between source qualifier transformations source filter to filter transformation?

1086

---

What is the use of an aggregator cache file?

1245

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1325

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8255

---

what is Active lock explain

2854

---

how to load rows into fact table in data warehouse

1224

---

Write the different tools in the workflow manager?

1112

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1552

---

Mention a few design and development best practices for informatica?

1042

---

where to store informatica rejected data?

1134

---

What is a shortcut and copy in Informatica and how two are different with each other?

1235

---

What does refresh system mean, and what are its distinctive choice?

1265

---

How to implement security measures using repository manager?

1231

---