Answer / shankar nm

Step 1. Have your valid mapping ready.
Step 2. Go to Debugger mode, set your breakpoints
Step 3. Activate view of target, output, input to ON
Step 4. choose View -> navigate to debugger, turn instance
data and target data ON by checking
Step 5. Use Func.Key or use mouse to go to next instance
check the output on target. follow the flow.

Alternate way is to check the SQL on TOAD to check the
number of rows meeting the criterion in each component.

Answer / praveen kumar pendekanti

Take 10 rows (use rownum<11 in session sql override) copy
that 10 rows and paste in excel sheet then run the session
there by we will get output as 10 rows then check that we r
getting 10 rows same as source and also check the business
logic and date conversions(carefully) if all these r
getting correctly there by capy that 10 rows from the
target table and paste that rows in excel sheet....
Dont forget to take paste the sql override query in excel
sheet and finally take the session log of that session and
add that one in excel sheet.......

very important don't override in mapping source qualifer ok


if i am wrong let me know

Answer / shashiall

prveen ..then where will we do SQL override?

Answer / dilip

I want to more to whatever is above, for the unit test
cases try to validate your all the transformation rule e.g
to_date,null check, look up cases and the stubbing cases if
any in the mapping.

when informatica 8 series released ?

1 Answers   IBM,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

can u any challenge your project?

0 Answers   HP,

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---

What is pmcmd command?

0 Answers  

---