Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic needs to join two sources in a source
qualifier?
- 3 Answers
- 7202 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sameer
1) Both sources should be from same Database.
2) They should have a common field which can be used for a
join.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
1. two sources must be from same datbase.
2.there should be primary-foreign key relationship between
them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi
1) both tables should have PK-FK relationship
2) both should have matching datatypes.
| Is This Answer Correct ? | 4 Yes | 2 No |
What is the difference between OLTP and ODS?
What is substr in informatica?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What the difference is between a database, a data warehouse and a data mart?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is olap (on-line analytical processing?
What is the difference between bitmap and btree index?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is plsql table?
What are batches?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Teradata 
