Answer / vaishali bisht

whenever we load data in flat file it automatically override the old data.

Answer / james

whatever data u want to delete from target table,simply go
with truncate option.

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

explain about unit testing? in real time?

0 Answers   L&T,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

explain different types of modeling.

2 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---