i having source, router transformation, two targets in my
mapping... i given two conditions in router
1)sal >500
2)sal < 5000
---------------
my source is havig two sal records (1)1000 (2)2000
then which target will load first? will both targets are get
load or single target only get load...... why?
Answer Posted / suresh
Given
sal>500
sal<5000
sal 1(1000)
sal 2(5000)
By using router transformation both targets are get loaded,because here two sal are greaterthan 500 and lessthan 5000.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Why union transformation is an active transformation?
What is a code page?
Where can we find the throughput option in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Make a note of the quantity vaults made in informatica?
Why do you use Mapping Parameter and mapping variable?
Under what condition selecting sorted input in aggregator may fail the session?
What are the databases that informatica can connect to windows?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is dimensional table?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.