Answer Posted / murthy

yes,there are many examples for this I will give one let's
take expresion using for ltrim and rtim operation,date
conversions etc.

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1743

---

Which transformation we use to convert 'NA' to 'Not Available'

1221

---

where is the cache (lookup, index) created and how can you see it.

1963

---

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2568

---

Identifying the bottlenecks in various components of Informatica and resolving them.

2558

---

What are the various tools used in etl?

969

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

885

---

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1672

---

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.

2306

---

if i have a query as flat file how can we load data to target table

1335

---

explain the methodology of Data Warehousing?(Polaries)

1934

---

How many steps etl contains explain with example?

880

---

what is the main role of FI on business

2034

---

How to delete data which is not in source table?

1266

---

What do you understand by active and passive transformations?

879

---