Answer / srini

The Dataset stage contains Two files one is Descriptor and
the other is Data file.Usually what we give in the file
path contains the Descriptor file and actual data will be
stoerd in the Data file with has same name but with Number
of partitions as the suffix in u r job.The location will
the what u mentioned in the config file for Resource disk.

What is datastage engine?

0 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

How did you reconcile source with target?

3 Answers   HP,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

Where the datastage stored his repository?

0 Answers  

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

what r the sources u need to create the datastage?

1 Answers  

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---