Answer Posted / 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

What are the measure objects?

1256

---

How many transformations can be used in mapplets.

1983

---

How can we use mapping variables in informatica?

1125

---

What are the reusable transformations?

1221

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1125

---

Can informatica load heterogeneous targets from heterogeneous sources?

1235

---

What is Data Caches size?

1130

---

What are the types of caches in lookup? Explain them.

1013

---

What are the prerequisite tasks to achieve the session partition?

1297

---

How does the aggregator transformation handle null values?

1197

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030

---

What is dynamic cache?

1086

---

In informatica workflow manager, how many repositories can be created?

1438

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339

---

Name the different lookup cache(s)?

1294

---