Answer Posted / santosh kumar sarangi

1. If source is relational then in SQ you can check the
distinct or in mapping we can use distinct in sorter t/r.
2.if flat file then distinct in sorter t/r.

It will not allow nay duplicate data, so target will get
only distinct data.

Let me know if any thing wrong.

Thanks & regards
Santosh Kumar Sarangi

What is data transformation manager process?

1091

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2518

---

What are the restrictions of union transformation?

992

---

Differentiate between a repository server and a powerhouse?

1060

---

Different sorts of metadata that stores in the storage facility?

963

---

What are active and passive transformations?

1033

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2034

---

What you know about transaction control transformation?

949

---

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

1159

---

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

1816

---

Can we get 1st record through Informatica(without sequence number).

1420

---

What do you understand by term role-playing dimension?

999

---

What is rank transform?

952

---

Separate from a database, an information bazaar, and an information stockroom?

1027

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

962

---