what is parallel querying and what r hints.
- 1 Answers
- 4518 Views
- I also Faced
- E-Mail Answers
Answer / sabyasachi
Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the types of lookup transformation?
Can anyone please distinguish what is Inner join and Outer join
Which transformation should u need while using the cobol sources as source defintions?
Why should we use star schema in datawarehouse design?
Define joiner transformation?
How many ways a relational source definition can be updated and what are they?
Where do we use mapping variables in informatica?
How will u find weather dimension table is big in size of a fact table?
What is the need for an etl tool?
 Informatica Checkpoints
explain different types of modeling.
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Teradata 
