Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56370 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / the tiklu
Materialized View is for Consumerist es, while Views
are for great men and sexy women.
| Is This Answer Correct ? | 7 Yes | 46 No |
Post New Answer View All Answers
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
where to store informatica rejected data? How to extract the informatica rejected data?
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?
What is option by which we can run all the sessions in a batch simultaneously?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain how many types of dimensions are available in informatica?
What is mapplet in informatica?
EXL informatica Questions
Define filter transformation?
what is the complex transformation you used in informatica
What is the use of source qualifier?
What are the types of data warehouses?
What is deployment group?
