Answer / prasad

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

How To find the location of APT_confid file

2 Answers   CTS,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

What is the difference between validate and compile?

1 Answers   CTS,

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

Can you define merge?

0 Answers  

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---