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 / lokendra
if 'salary= true' ,no records will come to target.
if only 'true' it will pass all the 10 records.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is a router transformation?
Differentiate between router and filter transformation?
what is the Default Source Option For Update Strategy Transformation?
what is unit testing?tell me proceedure
What is a pre-defined event and user-defined event?
Explain how many types of dimensions are available in informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain in detail scd type 2 through mapping.
What are the performance considerations when working with aggregator transformation?
what is size of u r database?
write a query to retrieve the latest records from the table sorted by version(scd)
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?