Answer / sanjay

Target option for flie: FTP, LOADER, MQ
For Relational : Oracle, Teradata, sybase, Informix etc.

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

---

Differnce between filter and router?

14 Answers   IBM,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

Explain pmcmd command usage in informatica

1 Answers   Informatica,

---

How many input parameters can exist in an unconnected lookup?

1 Answers  

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

explain different types of modeling.

2 Answers  

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---