Answer / akhil4

infromatica product known as informatica power center.it consist of 3components
1.informatica power center client tools
in this we have
a.designer
b.repository manager
c.work flow manager
d.work flow monitor
2.informatica power center repository
3.informatica power center server

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---