Interested to Buy Any Domain ? << Click Here >> for more details...
Hi experts,
table 1 has 10 records, table 2 has 5 records
select * from table1, table2;
What is the output for this query???....plz answer
- 3 Answers
- 7234 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyasen
(10*5) 50 records
this kind of query gives us Cartesian product
| Is This Answer Correct ? | 68 Yes | 0 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what is the Default Source Option For Update Strategy Transformation?
To import the flat file definition into the designer where should the flat file be placed?
How might you approve all mappings in the archive all the while?
What are the popular informatica products?
Define the various join types of joiner transformation?
Mention few power centre client applications with their basic purpose?
How do you load only null records into target? Explain through mapping flow.
What is a repository? And how to add it in an informatica client?
Explain target update override in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is intricate mapping?
