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 the size ur source like(file system or database)? how many record daily come u r banking project?

2137

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2129

---

What is main use of mapplet?

1125

---

What are session parameters ? How do you set them?

1841

---

Define enterprise data warehousing?

1195

---

What does “tail –f” command do and what is its use as an Informatica admin.

1095

---

What is the format of informatica objects in a repository?

1016

---

What is data caches/ index caches?

1091

---

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?

1967

---

What is fact table? Explain the different kinds of facts.

1072

---

Different sorts of metadata that stores in the storage facility?

1008

---

Which development components of informatica have the highest usage?

1029

---

Mention a few design and development best practices for informatica?

987

---

What do you understand by SOA of Informatica?

974

---

Differentiate between Load Manager and DTM?

2150

---