Answer Posted / saritha

craete a dummy table create table abc(source_name varchar2
(10),count number);

write a sp create or replace prod name

select count(*) into v1 from table name

insert into abc ( 'dvhadvav',v1);
commit;
end

import that sp in the maping and slecte the pro as sorce
pre load.

Repository user profiles

1811

---

What are the informatica performance improvement tips

1150

---

What is informatica etl tool?

1059

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2407

---

What is xml source qualifier transformation in informatica?

1278

---

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)

1676

---

What is sq transformation?

1230

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1711

---

What is flashback table ? Advance thanks

1998

---

Design time, run time. If you don't create parameter what will happen

1892

---

What is the need of an ETL tool?

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

1908

---

What are roles and groups and benefits of using them?

1103

---

What do you mean by blocking transformation?

1118

---

Sequence generator, when you move from develoment to production how will you reset

2123

---