Answer Posted / thava
I totally agree with Sai Krishna Karri that any
transformation
can be active or passive depends to the condition we
provided.
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
How can you define user defied event?
tell me about your project functionality
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What do you understand by SOA of Informatica?
How can one identify whether mapping is correct or not without connecting session?
Explain the code page compatibility?
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
What is dynamic cache?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Does an informatica transformation support only aggregate expressions?
permutations of mapplet
Where do we use mapping variables in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the difference between source qualifier transformations source filter to filter transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?