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
Explain in detail about scd type 1 through mapping.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
how we can load rejected record's at run time?(not through bad files)
How many numbers of sessions can one group in batches?
What is the function of union transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What could be the possible resons of locks by user?
Explain scd type 3 through mapping.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is mapping debugger?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is meant by active and passive transformation?
Explain about cumulative Sum or moving sum?
What is an aggregator transformation?
Write the unconnected lookup syntax?