By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?

Answer Posted / prasad.bluesky

it is possible to see the rejected rows after filter
transformation solution is create an empty file and write
that file name in $rejectfile option in session then after
run your session see your created file it contains rejected
rows.

Is This Answer Correct ?    10 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Scheduling properties,whats the default (sequential)

1704


How to generate sequence numbers using expression transformation?

860


What all join we can perform in LOOKUP transformation?

770


Explain in detail scd type 2 through mapping.

859


Which transformation should we use to normalise the COBOL and relational sources?

987


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1714


Name at least 5 different types of transformations used in mapping design and state the use of each.?

919


How can you define user defied event?

843


What is the maplet?

834


What are the different transaction levels available in transaction control transformation?

923


What are the types of schemas we have in data warehouse and what are the difference between them?

744


Explain about cumulative Sum or moving sum?

820


What is the difference between informatica 7.0 and 8.0?

765


What is persistent lookup cache?

812


Describe the impact of several join conditions and join order in a joiner transformation?

855