Answer Posted / kumar raja kotakonda
1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is expression transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is mean by complex business rule ?
How to convert multiple rows to single row (multiple columns) in informatica
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?
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
Where are the source flat files kept before running the session?
Explain lookup transformation in informatica
How can we create index after completion of load process?
What is native users?
can we override a native sql query within informatica? How do we do it?
What is the Rank index port in Rank transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
How do you load alternate records into different tables through mapping flow?