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.

how to insert header after each group.

1 Answers   IBM,

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

what is incremental aggregation ,with example?

2 Answers  

---

How do you implement configuration management in Informatica?

1 Answers  

---

What is hash partition?

1 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

---