Answer / sri

Using the Pivot we can convert the columns into rows

Answer / manu

By using 'ETERNAL PIVOT STAGE' we can do this

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  

---

How to add zero "0" before record in a field?

4 Answers  

---

how to add a new records into source?

0 Answers  

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

---

How many types of stage?

0 Answers  

---

What are operators in datastage?

1 Answers  

---

how to convert rows into columns

2 Answers   IBM,

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---