Interested to Buy Any Domain ? << Click Here >> for more details...
Can we combine a flatfile and a database table using an
UNION transformation?
- 2 Answers
- 12953 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
both the file and table metadata should same then we can join
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / surya
You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups
| Is This Answer Correct ? | 4 Yes | 2 No |
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
What are parallel querys and query hints?
What is an aggregator transformation? it is active why cant it be passive explain?
How to load query faster,so that It will take less time to load?
how can we load starting with 11th record of a table from source to target
What are the rank caches?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is rank transform?
What is galaxy shema
Teradata 
