for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
Answer Posted / krishna
I checked result.
Case 1: when you use filter condition sal=true
nothing will be moved to target table. session succeeded
but no data in target table.
Case 2: when you use only TRUE as filter condition.
all 10 records from source passes through filter to target
table .(in target table also we will get 10 records)
| Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
How to elaborate powercenter integration service?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the components of Informatica? And what is the purpose of each?
Why is sorter an active transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the issues you have faced in your project? How did you overcome those issues?
What is the way to execute pl/sql script using informatica mapping?
difference between informatica 8.1.1 and 8.6
Write the prerequisite tasks to achieve the session partition?
Separate from an archive server and a powerhouse?
Implementation methodology
Explain the types of transformations?
What is meant by a domain?
What is the difference between writing a joiner query in ANSI style and THETA style?