Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 11 Answers
- 22610 Views
- Accenture, I also Faced
- E-Mail Answers
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
What are the differences between source qualifier and joiner transformation?
what is unit testing?tell me proceedure
What are the types of data warehouses?
What is session task and command task?
How can a transformation be made reusable?
Differentiate between joiner and lookup transformation?
Explain load alternative records / rows into multiple targets - informatica
Briefly define a session task?
How an expression transformation differs from aggregator transformation?
What are the types of caches in lookup? Explain them.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what is the -ve test case in your project.
Design a mapping to load a target table with the following values from the above source?
my source is junk data how will u remove that junk data by using unix please any one replay me
