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 lookup change?
Describe data concatenation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the difference between mapping parameter and mapping variable?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a stored procedure transformation?
Differentiate between Load Manager and DTM?
What is a shortcut and copy in Informatica and how two are different with each other?
which one is better performance wise joiner or look up
What is a mapplet/worklet in informatica?
Explain the scenario which compels informatica server to reject files?
What is a sequence generator transformation?
what is INFORMATICA TESTING process
Explain about cumulative Sum or moving sum?
What is deployment group?