If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

---

What is the Router transformation?

2 Answers   Informatica,

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

can we use self join in informaitca?

3 Answers   IBM,

---

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

---