Answer Posted / reddymkl.dwh

Use Transformer Stage:
Take two stage variable
sv1= if sv2=DEPT_NO then sv1 : ' ' : EMPNAME
sv2= DEPT_NO
Derivation : Trim(sv1, ' ','L')
U will get output.

Is it possible to query a hash file?

2018

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2185

---

root tree will find which is server job and which is parallel job?

1976

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1544

---

Why do we use exception activity in Datastage?

1321

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2371

---

What is datastage engine?

1186

---

Differentiate between Join, Merge and Lookup stage?

1101

---

What all are the different way to run a job?

1096

---

To see hidden files in LINIX?

1537

---

How can you write parallel routines in datastage PX?

1022

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2487

---

How can we improve performance of data stage jobs?

1019

---

what is flow of project?

2007

---

Where do you see different stages in the designer?

1100

---