Answer / kishore

first of all Understanding Business requirements is the job of business analysts.
let the question was fired on the developer: then

First i will study the source system, and will try to figure out the business needs, if i didn't succeed in that, then i will discuss the issues with my business analysts.

source system study involves in understanding the relations between columns in a table, or fields in a flat file or data in a cobol file.

Answer / moorthy g

I'm working in Informatica support project:
In generally we say any new req. "ticket" Ex: INIT1113371
using this ticket no. we can able get the document through
remedy tool
and just go through the document and understand the
requirement. adding new column or remove column like that.
If we are removing any column means, first check it out
this column refered any table or not
after that only. we can remove the particular column.
adding new column is very easy. 1-1 mapping.
after finishing we prepare migration document. we will send
to customer for cutomer requirement.

what is sql override?what is the use of it?

4 Answers   Sonata,

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

which quality process u can approach in ur project

1 Answers   CTS,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---