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
What is exclusive and normal mode for repository services?
Write the program through which the records can be updated?
What is informatica worklet?
What is the advantage of informatica?
What is different between the data warehouse and data mart?
What is meant by incremental aggregation?
Which is the t/r that builts only single cache memory?
How can we update a record in the target table without using update strategy?
How might one distinguish in the case of mapping is right or not without associating session?
Can we create multiple integration service on single repository?
How many number of sessions can one group in batches?
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
difference between repository database and repository service?
r u done any partitions in ur project?
What is data movement mode in Informatica and difference between them?