Answer Posted / ankit kansal

Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||' '||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT

Using Oracle

select value from (
select id ||' '||upper(name) ||' '|| lead(upper(name),1) over (partition by id order by id) ||' '|| lead(upper(name),2) over (partition by id order by id) value from ankit_temp order by 1
)temp where length(value)>0 order by value;

http://deepinopensource.blogspot.com/

What is a joiner transformation?

998

---

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

1247

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2129

---

What is pmcmd command?

1129

---

Difference between Target-based loading and constraint-based loading?

1009

---

Make a note of the quantity vaults made in informatica?

989

---

How to convert multiple rows to single row (multiple columns) in informatica

1387

---

What is a filter transformation?

1050

---

What are the different types of transformation available in informatica.

1106

---

Which version configuration tool used in ur project?

3266

---

In informatics server which files are created during the session rums?

1121

---

What are the types of schemas we have in data warehouse and what are the difference between them?

946

---

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?

1981

---

Explain the shared cache and re-cache?

1124

---

Explain incremental aggregation in informatica

1137

---