Answer Posted / ignacy

dimension table is a structure

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2720

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

---

Partition, what happens if the specified key range is shorter and longer

2499

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2026

---

What is a shortcut and copy in Informatica and how two are different with each other?

1196

---

What is meant by query override?

1059

---

Explain the different lookup methods used in informatica?

1042

---

Explain the mapping variable usage example in informatica

1157

---

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

---

How do you load first and last records into target table?

1159

---

What are the different options available for update strategy?

1003

---

Explain transaction control transformation in informatica

1268

---

How to use pmcmd utility command?

1032

---

Explain the features of connected and unconnected lookup.

935

---

How do you set a varible in incremental aggregation

1891

---