whats the logic to load the lower level of granularity of
data to fact table.
No Answer is Posted For this Question
Be the First to Post Answer
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
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
What is the use of transformation?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
differences between service based and product based?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.