How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

Can you copy the session to a different folder or repository?

1 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

What is meant by pre and post session shell command?

0 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---