Answer / murali krishna

We can use Variable port in the following transformations.

1. Expression Transformation
2. Aggregated transformation
3. Rank Transformation

Answer / srikanth

hi
EXPRESSION T/R
AGGREGATE T/R
RANK T/R

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

what is materialized view?

2 Answers  

---

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Implementation methodology

0 Answers  

---

What is resilience time?

0 Answers  

---

Enlist the differences between database and data warehouse.

0 Answers  

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

What is an expression transformation?

0 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

what is confirmed dimension?

6 Answers  

---