Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
Answers were Sorted based on User's Feedback
Answer / jyothika
for eg,when v connect filter transformation (active) and
exp trfn (passive) to exp trfn.v get a notification
saying "not allowed".
| Is This Answer Correct ? | 1 Yes | 1 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
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
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suhel shaikh
Yes its valid we can pass the data from an active trans to
passive trans.
| Is This Answer Correct ? | 2 Yes | 4 No |
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.
| Is This Answer Correct ? | 3 Yes | 5 No |
Briefly explain the aggregator transformation?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
HOW TO YOU LOAD TIME DIMENSION
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
What are the different types of transformation available in informatica.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is distinct
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.