Answer / avni

1. Hash files is mostly used for lookups to avoid duplicates
2. Hash files acts as a reference table based on a key field
3. It can have any num of inputs and outputs and basically used to remove duplicates
4. It uses hashing algorithm to distribute data

Answer / prasad

Hash file is used to read data from/write data to Hash file.
it is used to remove duplicate from source data.

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

How can we achive parallelism

1 Answers   CTS,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

What modeling tool do you use?

6 Answers   HP,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

What are the areas of application?

0 Answers  

---

What is the difference between datastage and informatica?

0 Answers  

---

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

2 Answers   UHG,

---