Interested to Buy Any Domain ? << Click Here >> for more details...
can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 19990 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
I know 4 ways in INFORMATICA
1)Source Analyzer window-
(source table,Using key ports(enable,disable)).
2)Source qualifie Trans-
(Sql override)
3)Target override
4)Pre sql,Post sql
Any corrections,, srinu.srinuvas@gmail.com .
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
While migrating the data from one environment to another environment how would you manage the connections?
Where is metadata stored?
What is update strategy transform?
Different sorts of metadata that stores in the storage facility?
What do you understand by a term domain?
Explain the pipeline partition with real time example?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is event and what are the tasks related to it?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
While importing the relational source definition from the database, what are the metadata of source that will be imported?
how tokens will generate?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
