How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

How would you join a node to the already existing domain?

0 Answers  

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

explain about lookup t/r?

1 Answers   IBM,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

how to get the only updated records in the target

2 Answers  

---