What is enterprise data warehousing?
No Answer is Posted For this Question
Be the First to Post Answer
How do you join more than 3 flat files in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How the dimensions will be loaded?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What is degenerated dimention table?
what is parallel querying and what r hints.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
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
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?