Answer Posted / santhosh kumar n

powercentre powermart
---------------------------------------------------------
1)it is recommended to process 1) it is recommended to
process low volumesof
high volumes of data data

2)it can connect to ERP sources 2)it doesn,t support ERP
sources
such as SAP to perform extraction
3)it can upgrade from local to global(3)it doesn,t support
repository.

What is a standalone command task?

1177

---

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

7350

---

When do you use sql override in a lookup transformation?

1074

---

What is expression transformation?

1080

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5755

---

what is the difference between informatica6.1 and infomatica7.1

2249

---

Difference between Data and Index Caches?

1122

---

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

1935

---

What are session parameters ? How do you set them?

1819

---

difference between informatica 8.1.1 and 8.6

3657

---

What is workflow? What are the components of the workflow manager?

1099

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1023

---

What is the need of an ETL tool?

1068

---

Design a mapping to load a target table with the following values from the above source?

1324

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1019

---