Answer / sridhar

if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.

Answer / adisekhar

BY USING JIONER TRANSFOMATION WE CAN LOAD

Answer / seshagiri k

By using Target load order plan and based on primary foreign
keys to load the data into n no of dimensions



If it wrong pls send the correct answer to my mail

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

r u done any partitions in ur project?

0 Answers   TCS,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

---

What are the advantages of informatica?

0 Answers  

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---