Answer / srinu

In rare case some sessions will run long time ideally
without any data process.
The session log also will provide the information before
ideal run time only.
It occurs on server availability.

If the server hitting with many jobs at same time it
occurs.

Which kind of index is preferred in DWH?

2 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---

how did u understand business requirement?

2 Answers   TCS,

---

What are the new features of informatica 9.x in developer level?

0 Answers  

---