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.

expain about the tune parameters?

0 Answers   TCS,

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

What is dimensional table? Explain the different dimensions.

0 Answers  

---

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

in which situations do u go for scds ?

3 Answers   TCS,

---

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

---

What is target designer and target load order?

0 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---