Answer / sameer

i think if u want to convert flat-file source into xml then we can use xml transformation because using xml transformation we can convert flat file source as in xml using xml transformation

Answer / rahul

follow the below stepd to tune the joiner t/r ( which i
know)
1. select sort input and make sure that you send the sorted
data.
2. try to use normal join and master join than full and
detail join.
3.try to mark the master table which has less no.of rows

What are the features of complex mapping?

0 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---

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  

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

What is aggregate awareness?

1 Answers  

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---