Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
What are parameter files? Where do we use them?
What is the purpose of a staging area?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What are active transformation / passive transformations?
I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
What are the various tools? - Name a few?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Where do we use connected and un connected lookups?
How to determine what records to extract?
What are materialized views & where do we use them? What is a materialized view log?
How do you analyze the tables
How to present flrehird.log file from filling up the disk partition?
How to pipe multiline string to isqi?
How to connect with firebird database in delphi using tsqlconnection?