Answer / vidhyakarthik

SQ - Exp - Target

In exp transformation

newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3

pass newport4 to target

anyone pls confirm if it is wrong

Answer / dilip ingole

using SQL

SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;

Answer / mahesh

using Aggregator ......

create group by on col1

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

explain different types of modeling.

2 Answers  

---

Without source how to insert record to target?

6 Answers  

---

what are the deliverables?in your project?

0 Answers   DELL,

---

how we load the data from source to staging area

4 Answers   TCS,

---

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

Explain the types of lookup transformation?

0 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---