Interested to Buy Any Domain ? << Click Here >> for more details...
By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 47703 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / brahmareddy
filter transformation can't captured the rejected
files.rejected files are not appeared in session log or
rejected files
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sandeepbabu
in router transformation:Each row will be input for router transformation.
IF Row is TRue:for Uesr defined group condtion the data passes to the next transformation or target table,
IF Row is Flase:Uesr defined group condtion data will be passes to default group in router transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh
Hi, We can do this in two ways.
By using Filter transformation and By using router transformation.
By using filter transformation take two filter transformations and take two targets one for given condition and another for unsatisfied condition.
By using Router Transformation create one new group and give the condition take two targets and create pipeline between router trans and target1 and default group to target2.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abidu
Connect the ports of the filter transformation to the
second target table and enable the 'FORWARD REJECTED ROWS'
in the properties of the filter transformation. the
rejected rows will be forwarded to this table.
pls let meknow if i m wrong anywhere.
| Is This Answer Correct ? | 13 Yes | 17 No |
What is the Rank index port in Rank transformation?
What is CDC? How to implement CDC?
How to view and Generate Metadata Reports?
How to compare Source and Target table, without using dynamic lookup?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
Explain the difference between a data warehouse and a data mart?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
1 lac of flat fles in source how to load target at a time?
What is the difference between normal and bulk loading? Which one is recommended?
What is the difference between Bulk Load and Normal Load
How does a rank transform differ from aggregator transform functions max and min?
Teradata 
