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 / manojkumar
Hi Everybody,
Please check question again.
It is
" which target will load first? "
and
"will both targets are get
load or single target only get load...... why"
As per my knowledge,
It will load into two targets defenetly. There is no doubt
about it. And It will load same time into two targets or
first target will be first and second group target will be
next.
I am not sure about it. I am also searching answer for this
question.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Differentiate between router and filter transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
Define the various join types of joiner transformation?
without table how to come first record only in oracle?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Is it possible to revert a global repository to local one and why?
I have a flat file, want to reverse the contents of the flat file
How to update a particular record in target with out running whole workflow?
Is there any way to read the ms excel datas directly into informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is the size of your data warehousing?
What you know about transaction control transformation?
Why union transformation is an active transformation?