Answer / sanjeeva reddy

PIVOT STAGE

Answer / swetha

BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.

Name the different types of Lookups in Datastage?

0 Answers  

---

how will u design file watch jobs?

2 Answers  

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

How do you design PX Routines ?

1 Answers  

---

can explain wt is the pool for file.

1 Answers   CTS,

---

Which algorithm you used for your hashfile?

0 Answers  

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

what is use of SDR function?

0 Answers   CGI,

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---