Answer / kiran

This Questions Related for Informatica not in Datastage.

Answer / kalyanreddy

This question is belongs to informatica...

Answer / jayanthi

In Datastage, the same can be expalained as Normal
(Connected)Lookup and Sparse(unconnected) lookup.

For sparse lookup
When the refrence data volume is huge and primary volume is
very less,you can pass the input records key columns to
match against reference in refrence table extraction query
where clause.

How can u write exception handling in seq file????

2 Answers   IBM,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

Can you implement SCD2 using join, transformer and funnel stage?

1 Answers   Cognizant,

---

Name the command line functions to import and export the DS jobs?

1 Answers  

---

Explain how a source file is populated?

1 Answers  

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

Differentiate between validated and Compiled in the Datastage?

1 Answers  

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---

What are the partitioning techniques available in link partitioner?

1 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---