Answer / psnadh

Informatica 7.1:
Doesnot supports service oriented architecture & Universal
data access
Dynamic Partitioning & Push Down optimization is not
available
We cann't define our own userdefined functions

where as Informatica 8.1 supports all the above features

Answer / rajendra

I know only few difference

7.1:Java is not supported
No java source qualifier
8.1:Java is support
java source qualifier
Report generators(Not sure)

Answer / deepika

informatica 8.1 supports mainframe
data,java,adabase,sap,siebel.
it supports power exchange,to convert the data and gives it
to power center.

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

What is polling?

1 Answers  

---

what is the method of error handling when session is running?

1 Answers   TCS,

---