Answer / venky

src->sorter->exp->agg->tgt

sorter:-

select col1 key as sorter

exp:-

var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output_port=var1

agg;-

select group by col1

tgt:-

connect to target

Answer / hanan

src->exp->agg->tgt

src:-

In sql query write order by col1

exp:-

col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2

agg;-

select group by col1

tgt:-

connect to target

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

---

How union transformation is used?

0 Answers  

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

can we use self join in informaitca?

3 Answers   IBM,

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---