How can we append the data coming from multiple sources which dont have any relations into the flat file target which already exists and has data.
How to delete data from target table before insert starts without using truncate option in MappingThanks,
Latest Answer: Pre SQL: The SQL query fires initially when loading to that database.Example for Pre SQL: Suppose my requirement is to load the records daily. If some updates I have to reload the records for that particular day. In that case I will write a pre-SQL ...
Latest Answer: It is not possible to change the target table dynamically. According to me, we can change the connection of the table dynamically by changing the session properties. ...
Latest Answer: HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps ...
I have a requirement to lookup the same table twice with different keys one after another. If the first lookup fails then only the second lookup should be done. And, i have to use connected lookup to return
Informatica server is in Unix environment and other server is in Windows environment. I have to connect informatica server to other server .I am taking external procedure transformation in informatica
Latest Answer: Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.Ex:- if we have 100 customers and 200 products for 5 years of data for ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
