Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / 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

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / moorthy g

Both Condition Are Satisfied,
So, It will load two targets. (T1 And T2)

Is This Answer Correct ?    10 Yes 1 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / jayashree

Refer to Page 302 of Transformation Guide:
If a row meets more than one Group Filter Condition, then PC
Server passes this row multiple times.
Hence both the targets will be loaded

PC Server determines the order of evaluation for each
condition based on the order of connected output groups.
Hence first Target1 and then Target 2.

Is This Answer Correct ?    6 Yes 0 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / 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

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / jvdwhinfo

Hi Guys,

Both the targets are loaded with both the records as both
condition are satisfied.
And the order of loading is, first target 1 is loaded and
next target 2 is loaded as informatica loads target by
target.

Thanks.
James

Is This Answer Correct ?    1 Yes 0 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / sruthi

both targets get loaded.the first target gets loaded first and then the second.it cheks both the conditions,as both cannot be loaded in the same target,it loads the data even in the second target.

Is This Answer Correct ?    1 Yes 0 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / sameer

according to router group condition first load data the into target sal<500 and then load the data into the target sal<5000 because the informatica server check the group condtion according to router group then load then the data into the target means in target t1 1000 and then load taeget t2 5000

Is This Answer Correct ?    0 Yes 0 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / chandana

Use Target load order to specify which one to be loaded
first.

Is This Answer Correct ?    3 Yes 6 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Answer / 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

More Informatica Interview Questions

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,


What is a unit Testing?

1 Answers  


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  


What is Data Caches size?

0 Answers   Informatica,


In a sequential batch can you run the session if previous session fails?

4 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


How to load relational source into file target?

3 Answers   IBM,


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


Categories