Answer / naveen

It depends on ur project. am into production support. i get
almost 10 million of data per day.

Answer / akash

Usually the records count is in millions but the count
completely depends upon the business requirements and
varies from client to client.

It may be as low as in thousands and can go to millions of
records per day.

Answer / infa developer

Really was this question been aksed @ HSBC?

Answer / rkumar.etl

you need to work in realtime environment to get the
appropriate answers :)..

everyone pass the phase..specially from south india ..haa haaa

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

How many number of sessions that u can create in a batch?

3 Answers  

---

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---

Which kind of index is preferred in DWH?

3 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

How do you implement scheduling in Informatica?

1 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---