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 are the tasks that can be performed using sq?

1096

---

Explain the scenario which compels informatica server to reject files?

1172

---

Which is the t/r that builts only single cache memory?

1191

---

What is repository manager?

994

---

Please let me know how to make encryption and decryption with example?

1908

---

What are the differences between a connected lookup and unconnected lookup?

1071

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2428

---

How do you set a varible in incremental aggregation

1895

---

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

2073

---

What are the components of Informatica? And what is the purpose of each?

1059

---

Define pmcmd command?

1049

---

Whats there in global repository

1697

---

What is a router transformation?

1135

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1276

---

Enlist the tasks for which source qualifier transformation is used.

1044

---