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 |
What is meant by lookup transformation?
What is different between informatica version 8 and 9 version
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the difference between normal and bulk loading? Which one is recommended?
What is a taget load order?
What is Micro Strategy? Why is it used for?
How will you convert rows into columns or columns into rows
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
what is persistant cache in which situation we will use persistantcache
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
How to use pmcmd utility command?