Interested to Buy Any Domain ? << Click Here >> for more details...
Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
- 18 Answers
- 36226 Views
- L&T, I also Faced
- E-Mail Answers
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 |
Which is better performance wise database or file?How?
What is surrogate key?
If I have a index defined on target table and if set it to bulk load will it work ?
What is the difference between stop and abort in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
when we use dynamic lookup,if condition matches what will be the o/p?
why dimenstion tables are denormalized in nature ?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
How do you implement unconn. Stored proc. In a mapping?
What is sorter transformation?
Teradata 
