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
Answer Posted / dinesh
ans:select * from table 1,table2?
45 records(cartisan product)
| Is This Answer Correct ? | 0 Yes | 31 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the new features of informatica 9.x in developer level?
What is event and what are the tasks related to it?
Explain load alternative records / rows into multiple targets - informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What differs when we choose the sorted input for aggregator transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is a shortcut and copy in Informatica and how two are different with each other?
where to store informatica rejected data?
How to do unit testing in informatica? How to load data in informatica ?
What is the procedure for creating independent data marts from informatica 7.1?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?