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 / jani basha
both records are load into 1st target only.... because in
Router if 1st condition satisfies then it will not go to 2nd
condition....
Is This Answer Correct ? | 2 Yes | 22 No |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Define filter transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What are the different types of transformation available in informatica.
What is the difference between informatica 7.0 and 8.0?
What is a joiner transformation?
Explain in detail about scd type 1 through mapping.
write a query to retrieve the latest records from the table sorted by version(scd)
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
explain about unit testing? in real time?
What is the format of informatica objects in a repository?
What is lookup transformation?
In informatics server which files are created during the session rums?
How can we store previous session logs?
Enlist the tasks for which source qualifier transformation is used.