Answer / todearhari

you can Use cat -n flatFile>Target to Generate line numbers.

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

What are the types of hashed files in data stage

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

---

where we use config file as parameter ?

1 Answers   IBM,

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---