Answer Posted / swetha

In 7.5we have designer,director,manager,admin but in 8.0.1
manager includedd in designer.added some new stages range
lookup and scd stage.
connection objects are new objects that hold connection
information user name and password,database name to a
particular source or target which allows saving and reusing
connection information.
surrogate key generator stage whre will generate the
surrogate keysacrosss job execution runs.A new surrogate
key generator stage support following sources to generate
the sequence numbers(I)DB Sequence(II)File.
new connectors are invented the new connetors are easier to
use and extent functionality from existing connectors.

Name the different types of Lookups in Datastage?

1313

---

Explain usage analysis in datastage?

1224

---

What are orabulk and bcp stages?

1165

---

What are the functionalities of link partitioner?

1067

---

How to reverse the string using unix?

3592

---

What is orabulk stage?

1103

---

Nls stands for what in datastage?

1236

---

What are sequencers?

1172

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5191

---

Difference between server jobs & parallel jobs?

1130

---

What are the types of containers?

1310

---

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.

3402

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2535

---

What is the sortmerge collector?

1176

---

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.

4098

---