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.

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---

Describe stream connector?

0 Answers  

---

detail about sdlc

4 Answers  

---

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

---

What is data partitioning?

0 Answers  

---

specify data stage strength?

1 Answers  

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---