Answer Posted / sweta kedia

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

What is Index Caches size?

1094

---

What is an aggregator transformation?

1086

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1040

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7016

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1065

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1940

---

What is the difference between a repository server and a powerhouse?

1486

---

What is the session task and command task?

1034

---

Explain the types of lookup transformation?

1032

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10123

---

What is a repository? And how to add it in an informatica client?

1128

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1143

---

What is a difference between complete, stop and abort?

1071

---

Explain about Informatica server process that how it works relates to mapping variables?

1047

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2301

---