Answer Posted / sehaj

1)7.X IS SERVER ORIENTED
8.X IS SERVICE ORIENTED
2)7.X DOESNT CONTAIN ANY OPTION LIKE DYNAMIC FILE NAMING
WHEREAS 8.X CONTAINS AN OPTION LIKE DYNAMIC FILE NAMING
3)WE CAN CREATE USER DEFINED FUNCTIONS IN 8,X
4)SERVER FOLDERS NEED NOT BE CREATED IN 8.X.
5)TARGET DEFINATION CAN BE CREATED IN 8.X WITHOUT IMPORTING
TARGET IN THE MAPPING DESIGNER.
6)ONLY INFORMATICA SERVICE NEEDS TO BE STARTED IN 8.X WHERE
AS IN 7.X REPOSITORY SERVER N INFORMATICA SERVER NEEDS TO
BE STARTED BEFORE WORKING.
7)ADMIN CONSOLE OPENS IN AN INTERNET EXPLORER BROWSER.
8)SEQUENCE GENERATOR USES AN DATATYPE CALLED BIG INT.
9)MAX LIMIT OF SEQUENCE GENERATED CAN BE 8000000000+
10)THERE IS NO NEED OF CHANGING THE SERVER SETTINGS EACH
TIME WHEN DIFFERENT USER SITS ON THE MACHINE TO WORK IN HIS
REPOSITORY N SERVER....


SEHAJ......7204719446

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7588

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1113

---

Can anyone tell me the new features in Informatica 9 Version?

2207

---

How would you join a node to the already existing domain?

1180

---

What do you mean by enterprise data warehousing?

1109

---

How can we use mapping variables in informatica?

1123

---

What are the transformations that are not supported in mapplet?

1084

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1916

---

What is the need of an ETL tool?

1157

---

Explain the types of lookup transformation?

1104

---

What is meant by lookup transformation?

1180

---

What are the popular informatica products?

1056

---

What are the prerequisite tasks to achieve the session partition?

1295

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

---