Answer Posted / rathnakumar

select replace('111111111111ravi11111111kumar11111111111','1','') from dual;

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

996

---

What are session parameters ? How do you set them?

1772

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2263

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2094

---

Under which circumstances, informatica server creates reject files?

1024

---

Did u used latest transformations of 8.6.0? for what?

1821

---

Explain what are the different types of transformation available in informatica.

1036

---

What are the new features of informatica 9.x developer?

899

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1640

---

What are the guidelines to be followed while using union transformation?

1063

---

How many input parameters can exist in an unconnected lookup?

1489

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2071

---

What is lookup transformation?

1001

---

What is depict expression change?

1024

---

What you know about transaction control transformation?

934

---