If the records doesnt satisfy the filter condition where
will it go?

Answer Posted / basava

If the records does not satisfy the filter condition then
those records will be stored in $pmbadfile location in
informatica. This is the default path provided by
informatica, you can override this path in session properties.

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are roles and groups and benefits of using them?

561


What do think which one is the better joiner or look up?

712


What is meant by a domain?

615


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1324


difference between repository database and repository service?

610






What is dimensional table? Explain the different dimensions.

640


Explain what is informatica metadata and where is it stored?

599


how to load rows into fact table in data warehouse

628


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

588


How can you increase the performance in joiner transformation?

695


How to load last n records of file into target table - informatica

588


What all join we can perform in LOOKUP transformation?

549


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6742


According to his methodology what all you need before you build a datawarehouse

1179


What are different types of transformations available in informatica?

575