Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prasuna
Data Merging: It is a process of combning Non-Similar
structures or Similar structure data into Target Warehouse
system.
To combine Non Similar we can use Joins Concept,For
Similar We can use Union Concept
Data Cleansing:It is a process of converting Non Unique
data format of the source system into unique data format of
Target Warehouse system.
I dont Know definion for Data Sampling..can anyone plz give
the answer...
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
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 are the steps involved in the migration from older version to newer version of Informatica Server?
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,
Briefly explain the aggregator transformation?
What are the issues you have faced in your project? How did you overcome those issues?
What is DR strategy for Informatica project?
How to use pmcmd utility command?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is complex mapping?
How do you update the records with or without using update strategy?
How can we use mapping variables in informatica? Where do we use them?
Tell me about Propagate functions in informatica
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?
Please let me know how to make Data masking in informatica..
