Hi,
I've a mapping with flat file source
The target update override property for the target table is
using update
stmt.
There is no update strategy between source and target.
Also The session has the target properties as
Insert , Update as update options checked.
Does this mean that recs will be inserted only and the
update override will
not be applied at all.
Thanks
- 0 Answers
- 1565 Views
- I also Faced
- E-Mail Answers
Compare ETL & Manual development?
What is Data Vault???
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are the different Lookup methods used in Informatica?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
what is the meant by Normalization and de-normalization?
What are the differences between sql override and update override?
working of line item dimension......pls,tell overall flow
what is the use of structures?how many nodes can u create in a structure?
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.
Explain the difference between etl tool and olap tools?
Teradata 
