Answer Posted / lpet

GENERAL
Annotation
Container
Description Annotation
Link
Database
DB2/UDB
Dynamic RDBMS
Informix
ODBC
Oracle
RedBrick Load
Stored Procedures
Sybase
Teradata
UniVerse&UniData
File
Complex flat File
Folder
FTP Plug in
Hashed File
Sequential File
Processing
Aggregator
Datastage TX Map
Interprocess
Link Collector
Link Practitioner
Merge
Pivot
Row Merger
Row Splitter
Sort
Transformer
Real Time
XML Input
XML Output
XML Transformer

How you Implemented SCD Type 1 & Type 2 in your project?

3703

---

Lookup constraints

850

---

How to manage date conversion in Datastage?

652

---

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

2021

---

Can we use target hash file as a lookup ?

2824

---

---

what is the use of materialized view?

969

---

What is merge stage?

775

---

which r the connectors used in san?

1804

---

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

677

---

Define ds designer?

778

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1731

---

How can we improve the performance in datastage?

660

---

How many areas for files does datastage have?

650

---

What are the difference types of stages?

635

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

789

---