How to display null values on a target & non-null values on
a target?
Answers were Sorted based on User's Feedback
Answer / ramesh.b
hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.
source-->sq-->expression-->router-->2 targets
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / murugan
normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..
Is This Answer Correct ? | 3 Yes | 1 No |
what is datamart
What is transformation?
What is the need of etl tools?
What is the difference between writing a joiner query in ANSI style and THETA style?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Write the unconnected lookup syntax?
how to remove staging area
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is confirmed dimension and fact?
How You Pull the records on daily basis into your ETL Server.
explain about lookup t/r?