Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 30990 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dwhlabs
1> using dynamiclookup concept
2> using variable concept
First solution
source > sorter >dynamic lookup > filter > Target1 and
Target2
for more abt informatica mappings ... www.dwhlabs.in
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you load only null records into target?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Enlist few areas or real-time situations where informatica is required.
Sequence generator, when you move from develoment to production how will you reset
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the difference between a repository server and a powerhouse?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the mapping parameters and mapping variables?
What are the data movement modes in informatica?
How can you define user defied event?
list out all the transformations which use cache?
What is a passive transformation?
What are the differences between joiner transformation and source qualifier transformation?
