Answer / sri

Create FTP connection in workflow manager. In
session->mapping, assign created ftp connection to
source(flat file).

Hi, Lookup() is what kind of join ?

6 Answers   Satyam,

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

State the differences between shortcut and reusable transformation

0 Answers  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---

what are the data modeling tools you have used?(polaris)

0 Answers  

---

what is meant by drill through?(Mascot)

1 Answers  

---

what is granularity in Data ware House?

0 Answers   IBM,

---

What are the new features of informatica 9 version?

2 Answers  

---

Difference between flat files and relational sources?

0 Answers  

---