Answer Posted / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1048

---

What is sequence generator transformation in informatica?

994

---

What is aggregator transformation in informatica?

895

---

What is flashback table ? Advance thanks

1871

---

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

1738

---

where to store informatica rejected data?

1045

---

Define mapping and session?

966

---

What are the types of presistent cache in look up tr.

2004

---

Do you find any difficulty while working with flat files as source and target?

1050

---

What are the different clients of powercenter?

1006

---

Define enterprise data warehousing?

1128

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

981

---

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

1804

---

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

1401

---