Answer Posted / lajpat kurdiya

SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');

What is fact? What are the types of facts?

1120

---

what is the difference between cardinality and Nullability?

2950

---

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2127

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2219

---

What is the difference between round-robin partitioning and hash partitioning?

974

---

What is Data Vault???

2752

---

Compare ETL & Manual development?

957

---

how do u handle performance issues in Informatica . where can u monitor the performance ?

4741

---

When do we analyze the tables? How do we do it?

963

---

explain the methodology of Data Warehousing?(Polaries)

2301

---

Explain the key challenges that you face while performing etl testing.

1016

---

how to connect to a flatfile through ftp in informatica

14307

---

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2364

---

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2488

---

what is dynamic insert?

2210

---