What are the types of containers and how to create them?

0 Answers  

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

What are the different common services in datastage?

0 Answers  

---

How do you design PX Routines ?

1 Answers  

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  

---

Describe routines in datastage? Enlist various types of routines.

0 Answers  

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---