Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

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  

---

what is meta data? Explain? Where it is used?

9 Answers  

---

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

Define orabulk and bcp stages?

0 Answers  

---

Why do you need stage variables?

0 Answers  

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---