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

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---

what is surrogate id ?

3 Answers   IBM,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

What are the different tools in workflow manager?

1 Answers  

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

What is the benefit of session partitioning?

0 Answers  

---