Answer / manu

BY USING "FTP COMMAND" WE CAN CHANGE D FILES ONE SYSTEM TO
ANOTHER SYSTEM.

Answer / rk

i wank syntax of this command

Answer / aarthiangaiyan

Using Put command , syntax: Put srcfile tgtfile

Answer / vnrrahul

Use SCP command
ie: scp -P 2222 <File name> <username>@ < Destination IP><Destination Path>

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

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

1 Answers   TCS,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

How did you reconcile source with target?

3 Answers   HP,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

How we can covert server job to a parallel job?

0 Answers  

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  

---