Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeepbabu
Represents the source record set queried by the integration server/service.It is mandatory in the mapping when the source is relational or flat files.And it is a Active transformation.
source qualifier contain some properties is given bellow:
1>Sql query:It is generated by integration server by default and It contain Sql override,used to modify the default select Statmets...
2>user defined join:It is content of WHERE Clause to join separate Source
3>source filter:Filter applied to source Records..
4>Number of sorted ports:used to sort input ports.When we are using sorted ports the Powercenter add ports by default'Orderby'.BY default sorted ports are Zero
5>Select Distinct:selct unique values only
6>pre sql:The sql database before reads the source data
7>post sql:The sql database after write the data in to target table..
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Reusable transformation and shortcut differences
What is confirmed fact in dataware housing?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Enlist the tasks for which source qualifier transformation is used.
Which transformation is needed while using the Cobol sources as source definitions?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the difference between a connected look up and unconnected lookup?
What is a rank transform?
whats the logic to load the lower level of granularity of data to fact table.
What is informatica metadata and where is it stored?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How we can use union transformation?
What are the differences between oltp and olap?
how to load dimension table and fact table. plz tell me the steps.
