Answer / prabhu

You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again

Prabhu
www.iskilltech.com

Answer / ayodya

Using the Concat function can return Output

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

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 lookup chache?

1 Answers   Patni,

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

List the transformation in informatica.

1 Answers   TCS,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

What do you mean by enterprise data warehousing?

0 Answers  

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

What is a taget load order?

2 Answers   IBM,

---