Answer / swetha

source will gets inserted in target along with a new
version number. And newly added dimension in source will
inserted into target with a primary key.

Type2 Dimension/Flag current Maping: This maping is also
used for slowly changing dimensions.In addition it creates a
flag value for changed or new dimension.

Flag indiactes the dimension is new or newlyupdated.Recent
dimensions will gets saved with cuurent flag value 1. And
updated dimensions r saved with the value 0.

Type2 Dimension/Effective Date Range Maping: This is also
one flavour of Type2 maping used for slowly changing
dimensions. This maping also inserts both new and changed
dimensions in to the target. And changes r tracked by the
effective date range for each version of each dimension.

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

What is source qualifier?

6 Answers   SDS,

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---