Answer / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

Answer / rams

yes

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what is correlated query?

2 Answers   IBM,

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---