Answer / shar

Here are Uses:
1.We can generate sequence Numbers.
2.This will act as alternative to primary key.
3.we can pass the values with parameters.
4.we can pass the parameters at run time.
5.parameterization is possible.

cool...:)

Answer / vinod upputuri

Surrogate Key Stage is used to generate the Surrogate Key.

the main purpose of the Surrogate key is to maintain the
complete history in the dimension tables.

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

---

Name the different sorting methods in datastage.

0 Answers  

---

how do you pass parameters in a script?

1 Answers   L&T,

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

What modeling tool do you use?

6 Answers   HP,

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

Differentiate between datastage and informatica?

0 Answers  

---