1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / manojkumar

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


Please Help Members By Posting Answers For Below Questions

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8561

What is the difference between informatics 7x and 8x and what is latest version?

547

Explain the code page compatibility?

643

What are active transformations.

1188

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

710




What is the difference between stop and abort in informatica

663

Which are the different editions of informatica powercenter that are available?

558

What are the popular informatica products?

653

How to load data in informatica ?

574

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1534

How to update a particular record in target with out running whole workflow?

1158

how to load rows into fact table in data warehouse

642

How to elaborate powercenter integration service?

650

what is the -ve test case in your project.

1854

Why do you use Mapping Parameter and mapping variable?

1288