Answer / srinu

Hi Nithyanandan,,

The Debugger will show the data flow from Sql trans TO
Target only.
How source rows are transfor ONE Trans to Another Trans up
Target we can watch phisically also,
and watch the Rejected rows also.

srinu.srinuvas@gmail.com

Answer / kshetra

using verbose data in the session properties

Answer / sree

hi srini,

while running debugger , if u uncheck the option "Discard
target tables" u can pass the record.

Answer / nithyanandan

ther is no option in another transformation.
only possible using degugger(if there is any answer let me
know).

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

What is intricate mapping?

0 Answers  

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

what is confirmed fact?

2 Answers  

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---