Answer Posted / bharu_295

hi cdc stands for capture data change.

it is done by using incremental loading of the source data.

ex: in source take a column modified date

in mapping take sysdate as one column and get data with modifieddate>sysdate. condition.

What are the main issues while working with flat files as source and as targets ?

1136

---

What do think which one is the better joiner or look up?

1185

---

Differentiate between router and filter transformation?

1000

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1964

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1609

---

Can we create multiple integration service on single repository?

1172

---

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

1836

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1066

---

Clarify the utilization of aggregator cache record?

983

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2103

---

How can repository reports be accessed without sql or other transformations?

1200

---

What does update strategy mean, and what are the different option of it?

1081

---

write a query to retrieve the latest records from the table sorted by version(scd)

1049

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2084

---

What are the popular informatica products?

998

---