tell me 7.x and 8.x diferrencess(but not transformations)
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
In dimension and fact table? which one holds big data?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What are the ETL tools available in DWH?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is option by which we can run all the sessions in a batch simultaneously?
Why filter transformation is an active one?
What is the main difference between a Joiner Transformation and Union Transformation?
Enlist the differences between database and data warehouse.