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 / sruthi
both targets get loaded.the first target gets loaded first and then the second.it cheks both the conditions,as both cannot be loaded in the same target,it loads the data even in the second target.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Why is sorter an active transformation?
What is union transformation in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is informatica metadata?
Is it possible to use a client with different version than that of its Informatica server?
What are the different versions of informatica?
What is dimensional table? Explain the different dimensions.
What is repository manager?
Write the unconnected lookup syntax?
What is the difference between informatics 7x and 8x and what is latest version?
Define update strategy?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is flashback table ? Advance thanks
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)