Answer / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Answer / spandita

After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....

Answer / harish konda

First connect the exp1 with source and Sequence t/f's.

And next take the sorter and sort the data in descending
order of NEXTVAL port.

And again connect sorter to exp2 and connect sequence t/f to
this exp2.

And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

---

What are the measure objects?

0 Answers  

---

what is plsql table?

2 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

What are the mapping paramaters and mapping variables?

1 Answers  

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---