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.

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

What is the different lookup cache(s)?

0 Answers  

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

How can you join two tables without any common column present in them?

1 Answers   TCS,

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

Why update strategy and union transformations are active?

0 Answers  

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

what is junk dimension

4 Answers   Cap Gemini,

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,