what is the use of surogate key in datastage

2332

---

Plz can any one say me how to get the informatica certification materials and dumps

2059

---

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2164

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2475

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2134

---

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3580

---

what is Active lock explain

2813

---

What is Indexing? how did u implement indexing?

2487

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2599

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2456

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2301

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2255

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1916

---

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2194

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2740

---