Answer / john

Generally we all knew that is,In Datawarehouse
environment,we should load data first in the dimension
table then we load into the fact table..bcoz fact table
which contains the Primary keys of the dimension table
along with the measures.
So we need to check first that whether the fact table which
you are going to load that has foreign key relationship
with the dimension table or not?If yes,Use pipeline mapping,
and load dimension data first in first pipeline and in the
second pipeline load fact table data by taking the lookup
transformation on the dimension table which has loaded data
already..and return the key value from the lookup
transformation then calculate the measures by using
Aggregator and also give "group by" on the dimension keys
and map to the Target(Fact) prots as required.
most importantly specify the "Target Load Plan"
where dimesion target as first,fact table target as second.
let me pls correct my answer If i am wrong..

Answer / g. manthiramoorthy

Using dynamic lookup, you can load both simultaneously.

Answer / amedela chandra sekhar

use surrogate pipeline technique first data loaded into dimension table ,then loaded into fact fable with primary and foreign key technique b/w dimension and fact table.

use lookup t/r.........

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

performance tuning of Informatica

1 Answers  

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---