Answer Posted / ankita

Java transformation can be used to perform complex logic transformation for input data.

Generating intermediate records: For example ,a Java transformation contains two input ports that represent a start date and an end date. You can generate an output row for each date between the start date and end date. Using Loop : For example, you can define transformation logic to loop through input rows and generate multiple output rows based on a specific condition. -

See more at: http://www.tutorial.tecktricks.com/java-transformation-in-informatica-with-example/

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1675

---

In development project what is the process to follow for an etl developer from day1

1724

---

Explain constraint based loading in informatica

1093

---

What is aggregate cache in aggregator transformation?

1145

---

What are Dimensional table?

1055

---

What are the transformations that are not supported in mapplet?

1029

---

Please let me know how to make Data masking in informatica..

1722

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1264

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

How to implement security measures using repository manager?

1178

---

Explain the mapping variable usage example in informatica

1158

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1808

---

Explain scd type 3 through mapping.

1006

---

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

1863

---

What are the limitations of joiner transformation?

1114

---