informatica technical questions

7
Technical questions Architecture of informatica 8.6 Question regarding the difference between 7.6 and 8.1 Questions regarding the static, dynamic caches.. Difference between the connections given during mapping development and session developments Difference between mapping variable, session variables, mapping parameter and session parameters. Basic difference between loader connections, relation readers and other types.. Setting up the amount of data in session logs. Update and lookup transformation based questions Question based on views, materialiazed views Questions related to triggers, dblevel triggers, table level triggers, basic working and trigger developement. Can i change the datatype for the coloumns in source qualifier Scenario based questions col1 col2 col3 1 2 x 1 2 y 1 2 z Using the aggregator and following sql query, what will be my o/p from aggregator transformation to next level sql:- select col1,col2,col3 group by col1,col2 in lookup,sql query is overwritten with the following.. Selet a,b from C order by a q) how will my react if 1. Table C is same as my lookup table 2.Table C is different from my look up table. (check for syntax properly) Can i use order by clause for pushdown optimization ? if so how,what changes needs to be made in lkp properties Develop the mapping to for SCD type 2 level. Question based on Normalizer transformation.

Upload: shravan-tankasala

Post on 26-Dec-2015

7 views

Category:

Documents


0 download

DESCRIPTION

This material for informatica technical questions

TRANSCRIPT

Page 1: Informatica Technical Questions

Technical questionsArchitecture of informatica 8.6Question regarding the difference between 7.6 and 8.1Questions regarding the static, dynamic caches..Difference between the connections given during mapping development and session developmentsDifference between mapping variable, session variables, mapping parameter and session parameters.Basic difference between loader connections, relation readers and other types..Setting up the amount of data in session logs.Update and lookup transformation based questionsQuestion based on views, materialiazed viewsQuestions related to triggers, dblevel triggers, table level triggers, basic working and trigger developement.Can i change the datatype for the coloumns in source qualifier

Scenario based questionscol1 col2 col31 2 x1 2 y1 2 z

Using the aggregator and following sql query, what will be my o/p from aggregator transformation to next levelsql:- select col1,col2,col3 group by col1,col2

in lookup,sql query is overwritten with the following..

Selet a,b from C order by aq) how will my react if 1. Table C is same as my lookup table2.Table C is different from my look up table. (check for syntax properly)

Can i use order by clause for pushdown optimization ? if so how,what changes needs to be made in lkp properties

Develop the mapping to for SCD type 2 level.

Question based on Normalizer transformation.I have one target table resided in data base D. My 3 sources are in located in database A, database B, Database C.How will you load the target instance without using joiner transformation satisfying the unique constraints..

What are link conditions..?Explain with scenario.

InsertUpdate as Update

Page 2: Informatica Technical Questions

Update as insertUpdate else insert.

Can i perform insert, update and delete using update strategy .Give different options in the same.

Difference between ORACLE9i and ORACLE 10g.How analysing the table helps in performance improvement.

Write the query for analysing the table.What is dynamic partitioning in informatica...type of other partitioning we can use...How index is different from partition.Types of index and partitons in oracle.

Why we use stored procedure transformation?For populating and maintaining data bases.

42.What are the types of data that passes between informatica server and stored procedure?

3 types of data Input/ Output parameters Return Values Status code.

43.What is the status code?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 successfully. This value cannot seen by the user. It only used by the informatica server to determine whether to continue running the session or stop.

What is the target load order?Specify the target load order based on source qualifiers in a mapping. If u have the multiple source qualifiers connected to the multiple targets, U can designate the order in which informatica server loads data into the targets.

1.While importing the relational source definition from database, what are the meta data of source you import? Source name Database location Column names Datatypes Key constraints

2. Howmany ways U can update a relational source defintion and what r they?

Page 3: Informatica Technical Questions

Two ways 1. Edit the definition 2. Reimport the defintion

3.Where should U place the flat file to import the flat file defintion to the designer? Place it in local folder

4. To provide support for Mainframes source data,which files r used as a source definitions?

COBOL files5. Which transformation should u need while using the cobol sources as source defintions? Normalizer transformaiton which is used to normalize the data.Since cobol sources r oftenly consists of Denormailzed data.

6. How can U create or import flat file definition in to the warehouse designer?

U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat file.When the informatica server runs the session,it creates and loads the flatfile.

7.What is the maplet?

Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

8. what is a transforamation?

It is a repostitory object that generates,modifies or passes data.

9. What r the designer tools for creating tranformations?

Mapping designer

Page 4: Informatica Technical Questions

Tansformation developer Mapplet designer

10. What r the active and passive transforamtions? An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.

11. What r the connected or unconnected transforamations?

An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.

12. How many ways u create ports? Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.

14. What r the reusable transforamtions?

Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances automatically reflect these changes.This feature can save U great deal of work.

15. What r the methods for creating reusable transforamtions?

Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in mapping,U can revert it to the original reusable transformation properties by clicking the revert button.

Page 5: Informatica Technical Questions

16.What r the unsupported repository objects for a mapplet?

COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions

17. What r the mapping paramaters and maping variables?

Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change throughout the session.The informatica server saves the value of maping variable to the repository at the end of session run and uses that value next time U run the session.

18. Can U use the maping parameters or variables created in one maping into another maping? NO.We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.

19.Can u use the maping parameters or variables created in one maping into any other reusable transformation? Yes.Because reusable tranformation is not contained with any maplet or maping.

20.How can U improve session performance in aggregator transformation?

Use sorted input.

Page 6: Informatica Technical Questions