Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
Answer Posted / abhishek.x.upadhyay
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
When do we analyze the tables?
how to connect to a flatfile through ftp in informatica
How many steps etl contains?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain the key challenges that you face while performing etl testing.
what is data modeling?
where are the log files generally stored.Can you change the path of the file.what can the path be?
flat filevalidation in informatica
What are the different Lookup methods used in Informatica?
How can we use external procedural logic in informatica?
what is the main role of FI on business
explain the methodology of Data Warehousing?(Polaries)
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.
what are the types in error loging?
Can anyone explain me a scenario from banking and finance...more precisely a mapping