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.

Explain target update override in informatica

1116

---

explain abt ur project architecture?

2182

---

Can you generate sequence numbers without using the sequence generator transformation?

1110

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2029

---

How do you load only null records into target? Explain through mapping flow.

2007

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2046

---

Why filter transformation is an active one?

973

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1685

---

What do you mean by blocking transformation?

1029

---

Whats there in global repository

1685

---

What are the prerequisite tasks to achieve the session partition?

1243

---

What is the Process to creating lookup transformation in informatica

1038

---

Is there any target staging area in informatica not staging area

2569

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8213

---

Explain in detail scd type 2 through mapping.

1034

---