Answer Posted / balu

sourcce --> source qualifier--> sequence generator--
>expression trns-->target

generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.

How are indexes created after completing the load process?

1545

---

What is exclusive and normal mode for repository services?

1062

---

Why update strategy and union transformations are active?

989

---

without table how to come first record only in oracle?

2205

---

What is standalone command task?

1260

---

Differences between version 7.x and 8.x.

1840

---

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

991

---

Quickly characterize reusable change?

1058

---

Explain lookup transformation is active in informatica

1034

---

Mention a few design and development best practices for informatica?

933

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1874

---

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

1805

---

Can we override a native sql query within informatica?

987

---

How to elaborate tracing level?

1118

---