a interview question & datastage
TRANSCRIPT
-
8/2/2019 a Interview Question & Datastage
1/102
SQL IntroSQL SyntaxSQL Select
SQL DistinctColumn1
SQL Where
SQL And & OrSQL Order BySQL InsertSQL UpdateSQL DeleteSQL TopSQL LikeSQL WildcardsSQL In
SQL BetweenSQL AliasSQL Joins
SQL Inner JoinSQL Left JoinSQL Right JoinSQL Full JoinSQL UnionSQL Select IntoSQL Create DBSQL Create TableSQL Constraints
SQL Not NullSQL UniqueSQL Primary KeySQL Foreign Key
SQL CheckSQL DefaultSQL Create IndexSQL DropSQL AlterSQL Increment
SQL ViewsSQL DatesSQL NullsSQL isnull()SQL Data Types
http://e/Illayaraja%20300/sql/sql_top.asphttp://e/Illayaraja%20300/sql/sql_like.asphttp://e/Illayaraja%20300/sql/sql_wildcards.asphttp://e/Illayaraja%20300/sql/sql_in.asphttp://e/Illayaraja%20300/sql/sql_between.asphttp://e/Illayaraja%20300/sql/sql_alias.asphttp://e/Illayaraja%20300/sql/sql_join.asphttp://e/Illayaraja%20300/sql/sql_join_inner.asphttp://e/Illayaraja%20300/sql/sql_join_left.asphttp://e/Illayaraja%20300/sql/sql_join_right.asphttp://e/Illayaraja%20300/sql/sql_join_full.asphttp://e/Illayaraja%20300/sql/sql_union.asphttp://e/Illayaraja%20300/sql/sql_select_into.asphttp://e/Illayaraja%20300/sql/sql_create_db.asphttp://e/Illayaraja%20300/sql/sql_create_table.asphttp://e/Illayaraja%20300/sql/sql_constraints.asphttp://e/Illayaraja%20300/sql/sql_notnull.asphttp://e/Illayaraja%20300/sql/sql_unique.asphttp://e/Illayaraja%20300/sql/sql_primarykey.asphttp://e/Illayaraja%20300/sql/sql_foreignkey.asphttp://e/Illayaraja%20300/sql/sql_check.asphttp://e/Illayaraja%20300/sql/sql_default.asphttp://e/Illayaraja%20300/sql/sql_create_index.asphttp://e/Illayaraja%20300/sql/sql_drop.asphttp://e/Illayaraja%20300/sql/sql_alter.asphttp://e/Illayaraja%20300/sql/sql_autoincrement.asphttp://e/Illayaraja%20300/sql/sql_view.asphttp://e/Illayaraja%20300/sql/sql_dates.asphttp://e/Illayaraja%20300/sql/sql_null_values.asphttp://e/Illayaraja%20300/sql/sql_isnull.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_isnull.asphttp://e/Illayaraja%20300/sql/sql_null_values.asphttp://e/Illayaraja%20300/sql/sql_dates.asphttp://e/Illayaraja%20300/sql/sql_view.asphttp://e/Illayaraja%20300/sql/sql_autoincrement.asphttp://e/Illayaraja%20300/sql/sql_alter.asphttp://e/Illayaraja%20300/sql/sql_drop.asphttp://e/Illayaraja%20300/sql/sql_create_index.asphttp://e/Illayaraja%20300/sql/sql_default.asphttp://e/Illayaraja%20300/sql/sql_check.asphttp://e/Illayaraja%20300/sql/sql_foreignkey.asphttp://e/Illayaraja%20300/sql/sql_primarykey.asphttp://e/Illayaraja%20300/sql/sql_unique.asphttp://e/Illayaraja%20300/sql/sql_notnull.asphttp://e/Illayaraja%20300/sql/sql_constraints.asphttp://e/Illayaraja%20300/sql/sql_create_table.asphttp://e/Illayaraja%20300/sql/sql_create_db.asphttp://e/Illayaraja%20300/sql/sql_select_into.asphttp://e/Illayaraja%20300/sql/sql_union.asphttp://e/Illayaraja%20300/sql/sql_join_full.asphttp://e/Illayaraja%20300/sql/sql_join_right.asphttp://e/Illayaraja%20300/sql/sql_join_left.asphttp://e/Illayaraja%20300/sql/sql_join_inner.asphttp://e/Illayaraja%20300/sql/sql_join.asphttp://e/Illayaraja%20300/sql/sql_alias.asphttp://e/Illayaraja%20300/sql/sql_between.asphttp://e/Illayaraja%20300/sql/sql_in.asphttp://e/Illayaraja%20300/sql/sql_wildcards.asphttp://e/Illayaraja%20300/sql/sql_like.asphttp://e/Illayaraja%20300/sql/sql_top.asp -
8/2/2019 a Interview Question & Datastage
2/102
SQL Functions
SQL avg()SQL count()
SQL first()SQL last()SQL max()
SQL min()SQL sum()SQL Group BySQL HavingSQL ucase()SQL lcase()SQL mid()SQL len()
SQL round()SQL now()SQL format()
Describe the difference between a procedure, function and anonymous pl/sql block.What is a mutating table error and how can you get around it?
Describe the use of %ROWTYPE and %TYPE in PL/SQL
What packages (if any) has Oracle provided for use by developers?
Describe the use of PL/SQL tables
How can you generate debugging output from PL/SQL?
What are the types of triggers?
What are the components of physical database structure of Oracle database?What are the components of logical database structure of Oracle databaseWhat is a tablespace?
What is SYSTEM tablespace and when is it created?Explain the relationship among database, tablespace and data file ?What is schema?What are Schema Objects?
Can objects of the same schema reside in different tablespaces?What is Oracle table?What is an Oracle view?What is Full Backup ?What is the use of Control File ?What are Clusters ?What is an Integrity Constrains ?What is an Index ?
What is Table ?What are the advantages of views?What is an Oracle sequence?What is a synonym?
What is Rollback Segment ?How to define Data Block sizeWhat does ROLLBACK do ?
http://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asp -
8/2/2019 a Interview Question & Datastage
3/102
What does COMMIT do ?
Define Transaction ?What is a Schema ?What is Parallel Server ?What are roles? How can we implement roles ?
What is the use of transactional triggers?What is forms_DDL?Differentiate between TRUNCATE and DELETE?
Oracle cursor : Implicit & Explicit cursorsOther way to replace query result null value with a textWhat are the more common pseudo-columns?What is the output of SIGN function?
What is the maximum number of triggers, can apply to a single table?. What are PL/SQL Cursor Exceptions?Any three PL/SQL Exceptions?Which date function returns number value?
. Display Odd/ Even number of records
. Display the number value in WordsTo view installed Oracle version informationFind out nth highest salary from emp tableImplicit Cursor attributes. Explicit Cursor attributes
Oracle cursor : Implicit & Explicit cursorsDisplay the records between two rangeHow do I display row number with records?
How do I eliminate the duplicate rows ?Switch to DOS promptChange SQL prompt nameTo see current user name
Basic
50. What is 5NF?
49. What is 4NF?
What is BCNF (Boyce-Codd Normal Form)?
What is a Database?
What is DBMS?
What is a Database system?
Advantages of DBMS?
. Disadvantage in File Processing System?
. Describe the three levels of data abstraction?
Define the "Integrity Rules"
What is extension and intension?
What is System R? What are its two major subsystems?
How is the data structure of System R different from the relational structure?
What is Data Independence?
http://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asp -
8/2/2019 a Interview Question & Datastage
4/102
What is a view? How it is related to data independence?
What is Data Model?
What is E-R model?
What is Object Oriented model?
What is an Entity?
What is an Entity type?
What is an Entity set?
What is an attribute
What is a Relation Schema and a Relation?
What is degree of a Relation?
What is Relationship?
What is DDL (Data Definition Language)?
What is VDL (View Definition Language)?
What is SDL (Storage Definition Language)?
What is Data Storage - Definition Language?
What is DML (Data Manipulation Language)?
What is DML Compiler?
What is Query evaluation engine?
What is DDL Interpreter?
What is Record-at-a-time?
What is Set-at-a-time or Set-oriented?
What is Relational Algebra?
What is Relational Calculus?
. What is normalization?
What is Functional Dependency?
What is Multivalued dependency?What is 1 NF (Normal Form)?
What is 2NF?
What is 3NF?
What is BCNF (Boyce-Codd Normal Form)?
What is 4NF?
What is 5NF?
codd's rulesnormalizer
http://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asphttp://e/Illayaraja%20300/sql/sql_datatypes.asp -
8/2/2019 a Interview Question & Datastage
5/102
code page1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
D:\E-BOOK\exercise\2_ORACLE\1orclD:\E-BOOK\exercise\2_ORACLE\1orcl
1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl1orcl D:\E-BOOK\exercise\2_ORACLE\1orcl
http://e/Illayaraja%20300/sql/sql_datatypes.asphttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLEhttp://e/Illayaraja%20300/sqlhttp://../E-BOOK/exercise/2_ORACLE -
8/2/2019 a Interview Question & Datastage
6/102
2orcl D:\E-BOOK\DBMS\RDBMS\WORD
2orcl D:\E-BOOK\DBMS\RDBMS\WORD
2orcl D:\E-BOOK\DBMS\RDBMS\WORD
3orcl D:\E-BOOK\DBMS\RDBMS\WORD\3orcl
D:\E-BOOK\DBMS\RDBMS\WORD\3orclD:\E-BOOK\DBMS\RDBMS\WORD\3orcl
3orcl
D:\E-BOOK\DBMS\RDBMS\WORD\3orcl
D:\E-BOOK\DBMS\RDBMS\WORD\3orcl
http://e/Illayaraja%20300/sqlhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD -
8/2/2019 a Interview Question & Datastage
7/102
3orcl3orcl D:\E-BOOK\DBMS\RDBMS\WORD\3orcl3orcl
3orcl D:\E-BOOK\DBMS\RDBMS\WORD\3orcl
4orcl D:\E-BOOK\DBMS\RDBMS\WORD4orcl
4orcl
4orcl4orcl4orcl
4orcl4orcl4orcl4orcl
4orcl4orcl4orcl4orcl4orcl4orcl
4orcl4orcl4orcl4orcl4orcl4orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
http://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/4orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/3orclhttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD -
8/2/2019 a Interview Question & Datastage
8/102
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
5orcl D:\E-BOOK\DBMS\RDBMS\WORD
codds D:\E-BOOK\codd's
norm D:\E-BOOK\codd's
http://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/codd's/codds%20for%20relational.dochttp://../E-BOOK/codd'shttp://../E-BOOK/codd's/Oracle%20Normalization.dochttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd's/Oracle%20Normalization.dochttp://../E-BOOK/codd'shttp://../E-BOOK/codd's/codds%20for%20relational.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.dochttp://../E-BOOK/DBMS/RDBMS/WORDhttp://../E-BOOK/DBMS/RDBMS/WORD/5orcl.doc -
8/2/2019 a Interview Question & Datastage
9/102
What is Functional Dependency?What is hybrid slowly changing dimension?What is ER DiagramCan a dimension table contains numeric values?How to Create Surrogate Key using Ab Initio?Differences between star and snowflake schemas
What is degenerate dimension table?
What is a CUBE in datawarehousing concept?What is VLDBWhat are the vaious ETL tools in the MarketWhat is the main differnce between schema in RDBMS and schemas in DataWarehouse....?What is meant by metadata in context of a Datawarehouse and how it is important?What is Dimensional ModellingWhat is a linked cube?
What is surrogate key ? where we use it expalin with examplesWht r the data types present in bo?n wht happens if we implement view in the designer n report
What is data validation strategies for data mart validation after loading process
What is Data warehosuing Hierarchy?What is BUS Schema?
What is conformed fact?
What is Difference between E-R Modeling and DimentionalWhy fact table is in normal form?
What is the definition of normalized and denormalized view and what are the differences between themwhat is junk dimension?what is the difference between junk dimension and degenerated dimension?What is the main difference between Inmon and Kimball philosophies of data warehousing?
What is the difference between view and materialized viewWhat are the advantages data mining over traditional approaches?What are the different architecture of datawarehouseWhat are the steps to build the datawarehouseWhat is a source qualifierWhat is the difference between ODS and OLTP
What is the difference between datawarehouse and BI?What is the difference between OLAP and datawarehosue
what is aggregate table and aggregate fact table ... any examples of both
Kindly numberWhat are the steps to be taken to schedule the
explain in detail about type 1, type 2(SCD), type 3 ?What is active data warehousing?What is snapshot
Why do we override the execute method is struts? Plz give me the details?What is the difference between Datawarehousing and BusinessIntelligence?What is the difference between datawarehouse and BI?What is a bo repository
What are the process involved in the datawarehousing project cycle
http://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd's -
8/2/2019 a Interview Question & Datastage
10/102
What is Requirement gathering?
) What is JAD?
The approach that we use to decide which business intelligence tool to use are
) To decide which approach among buy v/s build has to be choosen for selecting the business intell
Explain the factors that are necessary for the database/hardware selection?
RDBMS/Hardware Combination: Because the RDBMS physically sits on the hardwareWhat are the popular relational databases?
Which are the most commonly used business intelligence tools
Which business tool provide flexibility in terms of each user to create, shedule & run their own reports?
) Which tool is used by the users to look at the data from the multiple dimensions?What is modeling technique used in datawarehousing?
What are the different levels of abstraction for a data model?
What is OLAP and also discuss its types?
) Dimensional data model is used for
What are the name of the tools in which people put the data modeling information?
What are the criteria for evaluating OLAP vendors
Modeling TypesModeling MethodsBusiness ProcessBusiness Process ToolsBusiness Process Management(BPM)Advantages of BPMBusiness Process Re-engineeringBusiness Process ModelingBusiness Process Modeling Tools
Business Process Modeling ExampleProcess Flow ModelingData Flow ModelingWorkflowsActivity Monitoring
Data Modeling ToolsTools: What to Learn?DM Tools - ErwinDM Tools - XcaseDevelopment Cycle
DM StandardsCreate a Data ModelData Modeler RoleModeling Reports
Conceptual DMEnterprise DMLogical DMPhysical DMLogical vs Physical
Relational(OLTP) DMDimensional DMRelational vs DimensionalDimensions
http://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd's -
8/2/2019 a Interview Question & Datastage
11/102
Slowly Changing Dimensions
DW ConceptsDW & Data MartStar SchemaSnowflake Schema
Fact TableETL ToolsETL ConceptsInformaticaInformatica - Transformations
Metadata ToolsBusiness MetadataTechnical Metadata
Metadata & ETLMetadata ReportsBI Overview
BI ToolsOLAP & HybridsOLAP AnalysisOLAP Database - MultidimensionalKey Performance IndicatorsBI DashboardsBI ScorecardsWhat is Data Mining?
http://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd'shttp://../E-BOOK/codd's -
8/2/2019 a Interview Question & Datastage
12/102
CODE PAGE1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH1DWH D:\E-BOOK\exercise\3_DWH
D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
http://../E-BOOK/codd'shttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/1DWH.DOC -
8/2/2019 a Interview Question & Datastage
13/102
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH2DWH D:\E-BOOK\exercise\3_DWH2DWH D:\E-BOOK\exercise\3_DWH2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH2DWH D:\E-BOOK\exercise\3_DWH2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
2DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
http://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.dochttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/DATAWARE%20HOUSE/qqqqq/3183782-datawarehousing-questions.doc -
8/2/2019 a Interview Question & Datastage
14/102
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH3 DWH D:\E-BOOK\exercise\3_DWH
http://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOChttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWH/3DWH.DOC -
8/2/2019 a Interview Question & Datastage
15/102
SERVER JOBS
UniVerse Stages DS Server jobUniData 6 Stages DS Server jobUniData stages DS Server jobSequential File stages DS Server job
Transformer stages DS Server jobAggregator stages DS Server jobFolder stages DS Server jobInter process DS Server joblink collector DS Server joblink partioner DS Server jobDataStage debugger DS Server jobcomplex flat file DS Server jobcomand stage DS Server job
merge DS Server jobpivot DS Server jobsort DS Server job
DS parll jobsParallel DS parll jobscomplex flat file DS parll jobsdataset DS parll jobsfile set DS parll jobslookup file set DS parll jobs
External source DS parll jobsExternal target DS parll jobsprocessing DS parll jobsAggregator DS parll jobs
transform DS parll jobschange apply DS parll jobschange capture DS parll jobsccompare DS parll jobscompress DS parll jobscopy DS parll jobs
Decode DS parll jobsDifference DS parll jobsEncode DS parll jobsExpand DS parll jobsExternal filter DS parll jobsFilter DS parll jobs
Funnel DS parll jobsGeneric DS parll jobsJoin DS parll jobs
Lookup DS parll jobsMerge DS parll jobsModify DS parll jobsPivot DS parll jobsRemove Duplicate DS parll jobssurrogate key generator DS parll jobs
http://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/3_DWHhttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20Server%20job.doc -
8/2/2019 a Interview Question & Datastage
16/102
switch DS parll jobsparallel data DS parll jobsparellel Restructure DS parll jobscolumn export DS parll jobscolumn import DS parll jobscombine Record DS parll jobs
Sub record DS parll jobsmake record DS parll jobspromote subrecord DS parll jobssplit subrecord DS parll jobssplit vector DS parll jobs
DS parll jobsMainframe
Delimited flatfileExtenal source
Fixed with flat fileMulti-format flat file
agggregatorBusiness ruleExternal routineftp
joinlookupsort
Development debug
column generatorheadpeekRow generator
sampleTailwrite range map
Sequence Jobs
Endloop activityException handlerExcute command
job activitynotification activityroutine activity
sequencerstart loop activityterminator activity
use variable activitywait for file activity
?????routine datastagedocsvariable datastagedocs
http://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.dochttp://../E-BOOK/exercise/1_DATASTAGE/new%20datastage/DS%20parll%20jobs.doc -
8/2/2019 a Interview Question & Datastage
17/102
parameter datastagedocscontainer datastagedocsrepository datastagedocsdesigner datastagedocsdirector datastagedocsadmin datastagedocs
manager datastagedocswhat are other performance tunings 51tell me one situation ur last project?had u solv the problem 61eliminate duplicate rows 80implement complex jobs 126/259pll for better performance 127diff btwn Informatica & datastages 142hasing algorithm/backup datastages 154debuging
create SCD 1 2 3 183how can call procedure 214how to you remove duplicates without using remove duplicate stage 215/219
job control/job sequence 243how can we test jobs in datastage 248unit/integrate testing 262hoe can find out process idexplain specific scenerio, whe wod we use range partioningHow to take backup of project?
1. What is the flow of loading data into fact & dimensional tables?2. Orchestrate Vs Datastage Parallel Extender?
3. Differentiate Primary Key and Partition Key?4. How do you execute datastage job from command line prompt?.What are Stage Variables, Derivations and Constants?5. What is the default cache size? How do you change the cache size if needed?6. Containers: Usage and Types?7. Compare and Contrast ODBC and Plug-In stages?
8. How to run a Shell Script within the scope of a Data stage job?9. Types of Parallel Processing?
10. What does a Config File in parallel extender consist of?
11. Functionality of Link Partitioner and Link Collector?
12. What is Modulus and Splitting in Dynamic Hashed File?
Types of views in Datastage Director?.Differentiate Database data and Data warehouse data?What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage18. What r XML files and how do you read data from XML files and what stage to be used?19. How do you catch bad rows from OCI stage?Suppose if there are million records did you use OCI? if not then what stage do you prefer?
-
8/2/2019 a Interview Question & Datastage
18/102
22. How do you pass the parameter to the job sequence if the job is running at night?What happens if the job fails at night?26. How do you track performance statistics and enhance it?27. What is the order of execution done internally in the transformer with the stage editor having input28. What are the often used Stages or stages you worked with in your last project?29. How many jobs have you created in your last project?
30. Tell me the environment in your last projects31. Did you Parameterize the job or hard-coded the values in the jobs?
32. Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you h
33. What is Hash file stage and what is it used for?
34. What are Static Hash files and Dynamic Hash files?
- What versions of DS you worked with?
39. Did you work in UNIX environment?
40. How good are you with your PL/SQL?
41. Explain the differences between Oracle8i/9i?
42. Do you know about INTEGRITY/QUALITY stage?39. Do u know about METASTAGE?
40. Do you know about INTEGRITY/QUALITY stage?
41. Explain the differences between Oracle8i/9i?
45. How did u connect to DB2 in your last project?
46. What are OConv () and Iconv () functions and where are they used?47. What are Routines and where/how are they written and have you written any routines before?&nb48. If worked with DS6.0 and latest versions what are Link-Partitioner and Link-Collector used for?Ans :
49. How did you handle reject data?What are other Performance tunings you have done in your last project to increase the performance of slowly run
50. How did you handle an 'Aborted' sequencer?Ans :
51. What are Sequencers?52. How did u connect with DB2 in your last project?53. Read the String functions in DS
54. What will you in a situation where somebody wants to send you a file and use that file as an input55. How would call an external Java function which are not supported by DataStage?56. What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Direct
57. What are the command line functions that import and export the DS jobs?58. How will you determine the sequence of jobs to load into data warehouse?61. Tell me one situation from your last project, where you had faced problem and How did u solve it?61. Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate62. How do you rename all of the jobs to support your new File-naming conventions?
http://www.geekinterview.com/question_details/12735http://www.geekinterview.com/question_details/12734http://www.geekinterview.com/question_details/12733http://www.geekinterview.com/question_details/12736http://www.geekinterview.com/question_details/12737http://www.geekinterview.com/question_details/12738http://www.geekinterview.com/question_details/12739http://www.geekinterview.com/question_details/12740http://www.geekinterview.com/question_details/12742http://www.geekinterview.com/question_details/12743http://www.geekinterview.com/question_details/12744http://www.geekinterview.com/question_details/12745http://www.geekinterview.com/question_details/12746http://www.geekinterview.com/question_details/12747http://www.geekinterview.com/question_details/12748http://www.geekinterview.com/question_details/12749http://www.geekinterview.com/question_details/12750http://www.geekinterview.com/question_details/12752http://www.geekinterview.com/question_details/12752http://www.geekinterview.com/question_details/12750http://www.geekinterview.com/question_details/12749http://www.geekinterview.com/question_details/12748http://www.geekinterview.com/question_details/12747http://www.geekinterview.com/question_details/12746http://www.geekinterview.com/question_details/12745http://www.geekinterview.com/question_details/12744http://www.geekinterview.com/question_details/12743http://www.geekinterview.com/question_details/12742http://www.geekinterview.com/question_details/12740http://www.geekinterview.com/question_details/12739http://www.geekinterview.com/question_details/12738http://www.geekinterview.com/question_details/12737http://www.geekinterview.com/question_details/12736http://www.geekinterview.com/question_details/12733http://www.geekinterview.com/question_details/12734http://www.geekinterview.com/question_details/12735 -
8/2/2019 a Interview Question & Datastage
19/102
63. Difference between Hashfile and Sequential File?64. How can we join one Oracle source and Sequential file?.65. How can we implement Slowly Changing Dimensions in DataStage?.66. How can we implement Lookup in DataStage Server jobs?67. What are all the third party tools used in DataStage?68. what is the difference between routine and transform and function?
69. what are the Job parameters?70.
Ans Performance and tuning of DS jobs
available.
71. How can we create Containers?72. When should we use ODS?
73. Whats difference betweeen operational data stage (ODS) & data warehouse?74. How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
75. How do you pass filename as the parameter for a job?
-
8/2/2019 a Interview Question & Datastage
20/102
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
-
8/2/2019 a Interview Question & Datastage
21/102
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
D:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastageD:\E-BOOK\exercise\1_DATASTAGE\new datastage
C:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_doc
-
8/2/2019 a Interview Question & Datastage
22/102
C:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_doc
C:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_docC:\Documents and Settings\Administrator\Desktop\LOTUSCRORE\ds_doc
-
8/2/2019 a Interview Question & Datastage
23/102
links on the lft hand side and output links?
ve taken in doing so?
ing jobs?
-
8/2/2019 a Interview Question & Datastage
24/102
Performance tuning in Informatica?
What are the out put files that the informaticaserver creates during the session running?
What is the target load order?What are the new features of the servermanager in the informatica 5.0?
Can you start a batches with in a batch?What are the diffrence between joinertransformation and source qualifiertransformation?
What are the new features in Informatica 5.0?In a sequential batch can you run the session if
previous session fails?Can you use the maping parameters orvariables created in one maping into any otherreusable transformation?
Can you generate reports in Informatcia?Can you copy the session to a different folder or repository?
Can you copy the session to a different folderor repository?Describe two levels in which update strategytransformation sets?
Why you use repository connectivity?What is source qualifier transformation?
What is incremantal aggregation?Explain about perform recovery?How the informatica server sorts the stringvalues in Ranktransformation?
In which circumstances that informatica server creates Reject files?What are the joiner caches?Performance tuning in Informatica?
What is the target load order?What are the new features of the server manager in the informatica 5.0?Can you start a batches with in a batch?What are the diffrence between joiner transformation and source qualifier transformation?
What are the new features in Informatica 5.0?Can you use the maping parameters or variables created in one maping into any otherreusable transformation?
What are the different options used to configure the sequential batches?What are the methods for creating reusable transforamtions?What is tracing level and what r the types of tracing level?How can u work with remote database in informatica?did u work directly by using
remote connections?
Why use the lookup transformation?What are the types of data that passes between informatica server and stored procedure?What is update strategy transformation?What r the circumstances that infromatica server results an unreciverable session?What is power center repository?What is Load Manager?What is Datadriven?What is meant by lookup caches?Define Informatica Repository?
-
8/2/2019 a Interview Question & Datastage
25/102
What are the types of maping wizards that are to be provided in Informatica?What is the Rankindex in Ranktransformation?What are two modes of data movement in Informatica Server?What is aggregate cache in aggregator transforamtion?What are Target Types on the Server?What are Target Options on the Servers?
What is the status code?Difference between static cache and dynamic cache?While importing the relational source defintion from database, what are the metadata of source you import?
What are Dimensions and various types of Dimensions?What are the session parameters?What is Session and Batches?What is Router transformation?What are the reusable transforamtions?
How can you access the remote source into your session?Where should you place the flat file to import the flat file defintion to the designer?Why we use partitioning the session in informatica?
What is parameter file?Which transformation should we use to normalize the COBOL and relational sources?Which transformation should you need while using the cobol sources as source defintions?What are the join types in joiner transformation?After draging the ports of three sources(sql server,oracle,informix) to a single sourcequalifier, can u map these three ports directly to target?
If i done any modifications for my table in back end does it reflect in informatcawarehouse or maping desginer or source analyzer?
Can you copy the batches?
Can you use the maping parameters or variables created in one maping into another maping?
1.What is target load order?
How do you configure mapping in informatica?
When conventional datawarehousing is able to handle and answer complex queries than wat is the need
How can we join 3 database like Flat File, Oracle, Db2 in Informatrica.?
How do you transfert the data from data warehouse to flatfile?
How can u work with remote database in informatica?did u work directly by using remote connections?
What is the Rankindex in Ranktransformation?
What is aggregate cache in aggregator transforamtion?
There are no target options for ERP target type
Difference between summary filter and details filter?
What is the diff b/w STOP & ABORT in INFORMATICA sess level ?What is difference between partioning of relatonal target and partitioning of file targets?
What are partition points?
What is parameter file?
Which transformation should we use to normalize the COBOL and relational sources?
Which transformation should u need while using the cobol
What are the join types in joiner transformation?
What is the logic will you implement to laod the data in to one
-
8/2/2019 a Interview Question & Datastage
26/102
Can you copy the batches?
What are the real time problems generally come up while
What is Micro Strategy? Why is it used for? Can any one explain in detail about it?
Waht are main advantages and purpose of using Normalizer Transformation in Informatica?
Can you use the maping parameters or variables created in one maping into another maping?
Can you copy the batches?Can any one explain real time complain mappings or complex transformations in Informatica.
what are the difference
What are the different threads in DTM process?
What is difference between maplet and reusable transformation?
Define maping and sessions?
What are the mapping paramaters and maping variables?
When you use the maping parameter ,U declare and use the
What are the tasks that Loadmanger process will do?
When you sart a session loadmanger fetches the session information from the repository to perform the
What is tracing level?
Can we run a group of sessions without using workflow