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
During the running session, output files are created by informatica server. Enlist few of them.
What are the informatica performance improvement tips
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What do you understand by a term domain?
What are the uses of etl tools?
What are the performance considerations when working with aggregator transformation?
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?
What do you mean by filter transformation?
How to create or import flat file definition in to the warehouse designer?
Enterprise data warehouse your projects phase by phase explain?
What is informatica powercenter repository?
How you can differentiate between connected lookup and unconnected lookup?