1] HOW DO U CHECK THE SOURCE FOR THE LATEST RECORDS THAT ARE TO BE LOADED INTO THE TARGET. I.E. I HAVE LOADED SOME RECORDS YESTERDAY, TODAY AGAIN THE FILE HAS BEEN POPULATED WITH SOME MORE RECORDS TODAY, SO HOW DO I FIND THE RECORDS POPULATED TODAY.
Answer: a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port f .
2] HOW U WILL CREATE HEADER AND FOOTER IN TARGET USING INFORMATICA?
Answer: If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties .
3] HOW CAN YOU SAY THAT UNION TRANSFORMATION IS ACTIVE TRANSFORMATION?
Answer: By Definition, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different.
4] HOW CAN I TRANSFORM ROW TO COLUMN?
Answer: Through Normalizer Transformation we can do this.
5] WHAT IS TRANSACTION?
Answer: Transaction is a logical unit of work that comprises one or more sql statements executed by a single user .
6] WHAT IS THE DIFFERENCE BETWEEN NORMAL LOAD AND BULK LOAD?
Answer: Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in su..
7] WHAT IS THE STATUS CODE?
Answer: Status code provides error handling for the informatica server during the session. The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.
8] WHAT IS THE RANK INDEX IN RANK TRANSFORMATION?
Answer: The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group.
9] WHAT IS DATADRIVEN?
Answer: The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject. If the mapping.
10] TO PROVIDE SUPPORT FOR MAINFRAMES SOURCE DATA, WHICH FILES ARE USED AS A SOURCE DEFINITIONS?
Answer: COBOL files.
11] CAN INFORMATICA LOAD HETEROGENEOUS TARGETS FROM HETEROGENEOUS SOURCES?
Answer: Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded.
12] CAN WE ELIMINATE DUPLICATE ROWS BY USING FILTER AND ROUTER TRANSFORMATION? IF SO EXPLAIN ME IN DETAIL.
Answer: U can use SQL query for uniqness if the source is Relational But if the source is Flat file then u should use Shorter or Aggregatot transformation.
13] WHAT IS PARAMETER FILE?
Answer: Parameter file is to define the values for parameters and variables used in a session. A parameter file is a file created by text editor such as word pad or notepad.
14] HOW DO YOU HANDLE DECIMAL PLACES WHILE IMPORTING A FLATFILE INTO INFORMATICA?
Answer: While importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer).
15] WHAT IS METADATA REPORTER?
Answer: It is a web based application that enables you to run reports against repository metadata. With a meta data reporter, You can access information about u r repository with out having knowledge of sql.
16] WHAT IS CODE PAGE COMPATIBILITY?
Answer: Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data.
17] WHY WE USE PARTITIONING THE SESSION IN INFORMATICA?
Answer: Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline. Informatica server can achieve high performance by partitioning the pipeline.
18] HOW DO YOU LOAD THE TIME DIMENSION?
Answer: Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc......
19] HOW CAN WE STORE PREVIOUS SESSION LOGS
Answer: Just run the session in time stamp mode then automatically session log will not overwrite current session log.
20] HOW CAN WE JOIN 3 DATABASE LIKE FLAT FILE, ORACLE, DB2 IN INFORMATRICA..
Answer: You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner.
Answer: a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port f .
2] HOW U WILL CREATE HEADER AND FOOTER IN TARGET USING INFORMATICA?
Answer: If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties .
3] HOW CAN YOU SAY THAT UNION TRANSFORMATION IS ACTIVE TRANSFORMATION?
Answer: By Definition, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different.
4] HOW CAN I TRANSFORM ROW TO COLUMN?
Answer: Through Normalizer Transformation we can do this.
5] WHAT IS TRANSACTION?
Answer: Transaction is a logical unit of work that comprises one or more sql statements executed by a single user .
6] WHAT IS THE DIFFERENCE BETWEEN NORMAL LOAD AND BULK LOAD?
Answer: Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in su..
7] WHAT IS THE STATUS CODE?
Answer: Status code provides error handling for the informatica server during the session. The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.
8] WHAT IS THE RANK INDEX IN RANK TRANSFORMATION?
Answer: The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group.
9] WHAT IS DATADRIVEN?
Answer: The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject. If the mapping.
10] TO PROVIDE SUPPORT FOR MAINFRAMES SOURCE DATA, WHICH FILES ARE USED AS A SOURCE DEFINITIONS?
Answer: COBOL files.
11] CAN INFORMATICA LOAD HETEROGENEOUS TARGETS FROM HETEROGENEOUS SOURCES?
Answer: Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded.
12] CAN WE ELIMINATE DUPLICATE ROWS BY USING FILTER AND ROUTER TRANSFORMATION? IF SO EXPLAIN ME IN DETAIL.
Answer: U can use SQL query for uniqness if the source is Relational But if the source is Flat file then u should use Shorter or Aggregatot transformation.
13] WHAT IS PARAMETER FILE?
Answer: Parameter file is to define the values for parameters and variables used in a session. A parameter file is a file created by text editor such as word pad or notepad.
14] HOW DO YOU HANDLE DECIMAL PLACES WHILE IMPORTING A FLATFILE INTO INFORMATICA?
Answer: While importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer).
15] WHAT IS METADATA REPORTER?
Answer: It is a web based application that enables you to run reports against repository metadata. With a meta data reporter, You can access information about u r repository with out having knowledge of sql.
16] WHAT IS CODE PAGE COMPATIBILITY?
Answer: Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data.
17] WHY WE USE PARTITIONING THE SESSION IN INFORMATICA?
Answer: Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline. Informatica server can achieve high performance by partitioning the pipeline.
18] HOW DO YOU LOAD THE TIME DIMENSION?
Answer: Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc......
19] HOW CAN WE STORE PREVIOUS SESSION LOGS
Answer: Just run the session in time stamp mode then automatically session log will not overwrite current session log.
20] HOW CAN WE JOIN 3 DATABASE LIKE FLAT FILE, ORACLE, DB2 IN INFORMATRICA..
Answer: You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner.
No comments:
Post a Comment