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

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

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?

1 Answers   HP,

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

What is Code Page Compatibility?

1 Answers  

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

---

task is running successfully but data is not loded why?

2 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---