Can you create a flatfile target
- 3 Answers
- 3220 Views
- ABC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nikita jain
yes, In Target design tab of Designer there are options like import from flatfiles also create table there we can select the type as flat file.
we can add the column names after creating the flatfile target instance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are active transformations? Name them.
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
what is lookup ?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
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 the limitations of pushdown optimization technique ? Advance thanks
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the different dimensions.
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What does role playing dimension mean?
Teradata 
