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
- 48345 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answer Posted / nagarjuna redd
Use router transformation to load the rejected data.
Connect output ports(i.e: condition satisfied records) to
the one target table and connect default ports(not
satisfied records) to the another target
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What you know about transaction control transformation?
What is data movement mode in Informatica and difference between them?
What does role playing dimension mean?
What are active transformations.
How can we remove the duplicates from flat file source?
scenario where i can use only concurrent execution of workflow.
In development project what is the process to follow for an etl developer from day1
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the advantage of informatica?
What are the types of data warehouses?
How do you promote a non-reusable transformation to reusable transformation?
