Answer Posted / bala

SQ used to read the data from relational source

Which are the different editions of informatica powercenter that are available?

1034

---

What is incremental aggregation?

1086

---

What is decode in informatica?

1165

---

What is workflow manager?

1049

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8203

---

Can we create a Integration service without a Repository service and vice versa?

1215

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5676

---

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?

10170

---

How can informatica be used for an organization?

1220

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

---

How to differentiate between the active and passive transformations?

1167

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1954

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391

---

Can we create two repositories on same database instance in oracle?

1095

---

Enterprise data warehouse your projects phase by phase explain?

1922

---