Answer Posted / psnadh

Hi,

In the source file if the row count is odd number,then how
can we check the condition to divide the ff into two halves?

If it is even,we can divide the ff into two halves as per
the above solutions.

Please give me reply how to implent that

Thanks in Advance

What is meant by active and passive transformation?

1031

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3812

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

What do you mean by blocking transformation?

970

---

wat are deployement groups in informatica, how it will be used for developers

1668

---

How will the document be delivered to me?

1018

---

Whats there in global repository

1641

---

Describe expression transformation?

1044

---

What differs when we choose the sorted input for aggregator transformation?

967

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9972

---

Have you worked with/created Parameter file

1611

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1012

---

What is a sequence generator transformation?

951

---

what is unit testing?tell me proceedure

2164

---

Performance tuning( what you did in performance tuning)

1908

---