By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / avinash
u can not pass the rows if condition is not satisfy .
| Is This Answer Correct ? | 80 Yes | 4 No |
Post New Answer View All Answers
What are batches?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the types of lookup transformation?
What are the static cache and dynamic cache in informatica?
Explain the difference between a data warehouse and a data mart?
What is a node in Informatica?
What is xml source qualifier transformation in informatica?
What is meant by LDAP users?
what are the Methods For Creating Reusable Transformations?
how tokens will generate?
Define filter transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Global and Local shortcuts. Advantages.