can we override a native sql query within informatica? Where do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
how do the project develops? pls specify right from the start to end in step by steps.
How do you load first and last records into target table?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
in which situations do u go for sequence generator ?
What are the Differences between static cache and dynamic cache?
Can you start a session inside a batch individually?
What is Datadriven?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?