Answer / dharmendra singh

Use one more session after your current session which reads
from bad file and load into a flat file.In post session
command of new session you can call a shell script which
checks flat file for non zeror records and send email
accordingley.If record count in flat file is non zero it
should send an email.

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

---

Define sessions in informatica etl?

0 Answers  

---

What are the connected or unconnected transforamations?

2 Answers  

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---