Answer / prasuna

its invalid..we shouldnot connect active n passive together.

Answer / vissu

pls give an example for that

Answer / jyothika

for eg,when v connect filter transformation (active) and
exp trfn (passive) to exp trfn.v get a notification
saying "not allowed".

Answer / umaa devi

In the above question,active and passive transformations
are in two different pipelines.Simultaneousely data is
passed from active and passive transformations into passive
transformation.Sorry , all guys.

Answer / etl maha maha maha muduru

yes valid.suppose take sequence generator t/r drag the
nextval port into exp t/r from exp t/r drag all ports into
router t/r,from router t/r drag default group into one target.
when u connect default group into target then it is passive.

Answer / chandru

if the date is passed from one active an one passive cannot be connected to the passive transformation the mapping is not valid

but there is a possible way if we have expression(passive) an aggreatror(active) we can connect these active an passive transformation through joiner (active) transformation it is possible

Answer / suhel shaikh

Yes its valid we can pass the data from an active trans to
passive trans.

Answer / zaheer

No, it is not possible to move data from ACTIVE & PASSIVE to
PASSIVE. Either both transformation should be ACTIVE or
PASSIVE in pipeline.

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

tell me the push down optimization

2 Answers   Wipro,

Could any one to tell Fact table Partitioning?

2 Answers  

What is synonym?

2 Answers   Patni,

how to get the first row without using rank t/r?

7 Answers   iGate,

what is mapping performence?

2 Answers   Cap Gemini,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

What is sql query override? When did u use sql query override?

1 Answers   TCS,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,