Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6374 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
if ur sources are flat files then you cannot give any SQ
override queries.
to join 2 flatfile sources you need to have a joiner
transformation.
If ur target is a flat file, the loading process is very
fast as its a bulk load where there will be no constraints
( no checks)
You can have number and char data types... but for dates,
you need to convert explicitly
many more diff are there...
You can use indirect method and use many flatfiles of same
structure and load to a target using one session and
workflow tasks.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is the difference between cardinality and Nullability?
Compare ETL & Manual development?
What is meant by incremental load?
What are the differences between sql override and update override?
What is virtual Data Warehousing?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
explain the methodology of Data Warehousing?(Polaries)
explain the methodology of Data Warehousing?(Polaries)
what are the facilities provided by data warehouse to analytical users?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
When do we analyze the tables? How do we do it?
When do we analyze the tables?
What are the different etl testing categories as per their function?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
