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 / moorthy g
Both Condition Are Satisfied,
So, It will load two targets. (T1 And T2)
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Describe expression transformation?
What is the difference between informatica 7.0 and 8.0?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can we delete duplicate rows from flat files?
can we override a native sql query within informatica? Where do we do it?
what is Active lock explain
What are the mapping parameters and mapping variables?
what is diff b/t sorter t/r and agg have the option sorter property...
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the use of target designer?
What are active and passive transformations?
Which development components of informatica have the highest usage?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
explain about unit testing? in real time?
What are the tasks that source qualifier perform?