Answer / shweta

Actually its important to use a update strategy
transofmration in the SCD's as SCDs maintain some historical
data specially type 2 dimensions. In this case we may need
to flag rows from the same target for different database
operations. Hence we have no choice but to use update
strategy as at session level this will not be possible.

Answer / srinu

Hi,

Seession Properties like pre Souurce Rows
INSERT,UPDATE,REJECT,DELETE ,,
Using Session Properties We can do single flow only.

SCD aplicable for Insert,Update,,at a time using Update
Strategy trans only.
Using Update Trans we can creat SCD mapping easily.


Any Corrections Let me know
srinu.srinuvas@gmail.com

Answer / akhil4

using update stratagey tr (or)session properties both are same.update stratagey using at mapping level,session properties using at wf level. (it's wrong correct me)

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

How can you generate reports in informatica?

0 Answers  

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---

What are the types of metadata that stores in repository?

2 Answers  

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---