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 do you mean by blocking transformation?
What is meta data and system catalog?
What is polling?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Label in Informatica. How to remove existing Label.
How to extract sap data using informatica? What is abap? What are idocs?
If we set dd_insert in mapping and Delete in session properties what will happen.?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
From where we can start or use pmcmd?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Explain target update override in informatica