what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

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,

---

What are transforms and what is the differenece between routines and transforms?

0 Answers  

---

What is the command line function to import and export the ds jobs?

0 Answers  

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

How do you find the number of rows in a sequential file?

1 Answers  

---