DataStage and Informatica
Explain the term DataStage and Informatica?
Expert
a) Data Stage support the parallel processing however the informatica doesn’t.
b) Links are the objects within the DataStage ,in the Informatica it is a port to port connectivity .
c) In the Informatica it’s easy to execute the Slowly Changing Dimensions that is quite complex in the Data Stage.
d) Data Stage doesn’t support the whole error handling.
Write down the importance for using repository connectivity?
Illustrate the term data mart. What do you mean by it?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain the working of the IPC Stage?
What is meant by the term Context?
Explain the command line functions which export and import the DS jobs?
Explain about the Active and Passive Stage?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
18,76,764
1930291 Asked
3,689
Active Tutors
1419414
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!