Answer Posted / soundarya

we can use $$$SessStartTime in Mapping or mapplet filter
conditions

User-defined joins

SQL overrides
in designer and workflow manger also

We can use SESSSTARTTIME in Expresion in the designer

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1633

---

What do you mean by blocking transformation?

1041

---

Define sessions in informatica etl?

1035

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

What is the benefit of session partitioning?

1116

---

Explain load alternative records / rows into multiple targets - informatica

1153

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1109

---

State the limitations where we cannot use joiner in the mapping pipeline?

1067

---

How to use pmcmd utility command?

1033

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5794

---

Explain why we use partitioning the session in informatica?

1094

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1069

---

How to load the data from people soft hrm to people soft erm using informatica?

1020

---

What is informatica etl tool?

1000

---

differences between service based and product based?

2016

---