Answer Posted / anjan

select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)

how to load dimension table and fact table. plz tell me the steps.

2084

---

What are the types of schemas we have in data warehouse.

946

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1986

---

What is an aggregator transformation?

1087

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1071

---

How we can use union transformation?

1038

---

Which transformation should we use to normalise the COBOL and relational sources?

1182

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

995

---

What do you mean by channel change?

1022

---

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

7358

---

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

5644

---

How to go to the older version for a mapping?

1068

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1493

---

How to extract sap data using informatica? What is abap? What are idocs?

1159

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2140

---