Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 21690 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
what is degenerated dimension?
what is size of u r database?
Explain scd type 3 through mapping.
What is informatica powercenter repository?
How do you promote a non-reusable transformation to reusable transformation?
What are the uses of etl tools?
Separate from a database, an information bazaar, and an information stockroom?
What is the benefit of session partitioning?
How to handle decimal places while importing a flatfile into informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Describe the impact of several join conditions and join order in a joiner transformation?
Have you worked with/created Parameter file
How can we use mapping variables in informatica? Where do we use them?
How big was your fact table
How to load the data from a flat file into the target where the source flat file name changes daily?
