Answer Posted / babu

Hi Teja,
The two sources are haveing same structure,so beter to
use list file,to load the data into single TARGET.

Procedure:
----------
1.Place the two source paths in a note pad and
save as it '.list' format.
2.create a maping as per your requirement in
that mapping you have to take only one source no need to
take two sources.
3. Create a session and workflow.
4.In session give a SOURCE FILE PATH
is '.list' file and SOURCE FILE TYPEA as INDIRECT.

Let me know if any thing wrong.

Thanks,
dwarak.vbr@gmail.com

What are the conditions needed to improve the performance of informatica aggregator transformation?

578

---

Explain incremental aggregation in informatica

651

---

What are the tasks that can be performed using sq?

610

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1407

---

What is a stored procedure transformation?

608

---

---

What is resilience time?

652

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

535

---

How do you promote a non-reusable transformation to reusable transformation?

658

---

What is xml source qualifier transformation in informatica?

712

---

Enlist some properties of sessions.

623

---

Differentiate between a database and data warehouse?

651

---

Does an informatica transformation support only aggregate expressions?

606

---

 Informatica Checkpoints

2853

---

Design time, run time. If you don't create parameter what will happen

1424

---

What are the static cache and dynamic cache in informatica?

710

---