Answer Posted / sweta kedia

Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)

How might you approve all mappings in the archive all the while?

956

---

What are the tasks that source qualifier perform?

1030

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1027

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133

---

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

1996

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2389

---

How to go to the older version for a mapping?

1028

---

what are the Methods For Creating Reusable Transformations?

1099

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1995

---

What is lookup change?

986

---

whats the logic to load the lower level of granularity of data to fact table.

2206

---

Enlist few areas or real-time situations where informatica is required.

1019

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057

---

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?

6354

---

can you please explain me pre session and post session options?

7402

---