Answer Posted / raj

Hello Chowdary... Using one source file only not two source
files he is asking first look into the question and answer
in the proper way...

What are constraints and derivations?

1111

---

How to reverse the string using SQL?

1424

---

sed,awk,head

1408

---

What is a folder? Difference types of stages?

1102

---

What is the difference between hashfile and sequential file?

1185

---

What is the method of removing duplicates, without the remove duplicate stage?

958

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3967

---

Define oconv () and iconv () functions in datastage?

1340

---

How will you move hashed file from one location to another location?

2090

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1069

---

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

1095

---

Differentiate between Join, Merge and Lookup stage?

1036

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1504

---

How one source columns or rows to be loaded in to two different tables?

1070

---