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
Briefly explain the aggregator transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can we delete duplicate rows from flat files?
What is the difference between Active and Passive transformation?
What is the sequence generator transformation in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain the etl program with few examples.
What are the limitations of joiner transformation?
What are the tuning techniques you applied during your last project
What is fact table? Explain the different kinds of facts.
What is powercenter on grid?
Mention a few design and development best practices for informatica?
can anyone explain me about retail domain project in informatica?
What are some examples of informatica etl programs?