Answer / aparna

stop command immediately kills the reading process and does
not have any time period

Abort command gives a time out period of 60sec to the
informatica server to finish the dtm process else it kills

Answer / abhinaw prakash

STOP:When we issue Stop command the integration service
stops reading data from the source though it keeps on
processing and committing the data to the target.

ABORT: When we issue Abort command the integration service
has a timeout period of 60 sec.If its not able to finish
processing and committing the data to the target it kills
the DTM session.

what is materialized view?

2 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

How to join three sources using joiner?

0 Answers  

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

What are the reusable transforamtions?

2 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---