What does role playing dimension mean?
No Answer is Posted For this Question
Be the First to Post Answer
4 yrs etl devloper roles and responsibilities?any body give solutions
write a query to retrieve the latest records from the table sorted by version(scd)
How to load a Dimension ? and how to load a fact table?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
How will the document be delivered to me?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
what is difference between COM & DCOM?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is target load order?
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 are the tuning techniques you applied during your last project