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>

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---

difference between function and procedure...

1 Answers   IBM,

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---