Answer / hanug

To use environment variable at the project or job level, we
should first check if the environment variable already
present at the project level. If the environment variable
does not exist, we should create the one and then it should
be used at the project level or at the job level.

To use the environment variable you just need to add to the
project or job.

Differentiate between validated and Compiled in the Datastage?

0 Answers  

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

which r the connectors used in san?

0 Answers  

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

Why we need datasets ratherthan sequential files?

5 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

---