Answer Posted / babu

Hi All,

SRC==>SQ==>EXP1==>SRTR==>EXP2==>RTR==>TG1
|| || ||
SEQ1 SEQ2 ==> TG2

EXPEL NATION OF MAPPING
=======================

1.EXP1: ADD ONE OUTPUT PORT AND ASSIGN THE NEXT VAL PORT FROM SEQ1 TO OUTPUT PORT.
i.e: O_SEQ1=SEQ.NEXTVAL
2.SRTR:SORT THE COLUMNS BASED ON THE O_SEQ1 IN DESCENDING ORDER.
3.EXP2:ADD ONE OUTPUT PORT AND ASSIGN THE "NEXT VAL PORT" FROM SEQ2 TO THIS OUTPUT PORT.
i.e:O_SEQ2=SEQ2.NEXTVAL
4.RTR: GRP1(O_SEQ1>=O_SEQ2)
GRP2(O_SEQ1<=O_SEQ2)(DEFAULT GROUP)

Quickly characterize reusable change?

1117

---

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

5670

---

How to extract sap data using informatica?

1042

---

Can you generate sequence numbers without using the sequence generator transformation?

1118

---

What you know about transaction control transformation?

992

---

What is blocking transformation?

1140

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3700

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2143

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861

---

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

1504

---

How to load data in informatica ?

1001

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1500

---

How to delete duplicate row using informatica?

1041

---

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?

1007

---

Separate from a database, an information bazaar, and an information stockroom?

1084

---