in a table it has 200 rows the query is select 150 from
tablename.whats the output
Answers were Sorted based on User's Feedback
Answer / babu
Hi all,
it is very simple.
if you give any number in the select list it will displays the
that number(how many records table havie that number of times)
Ex: select 200 from tab
Ans:200
200
200
--
--
200(200 times)
Is This Answer Correct ? | 7 Yes | 3 No |
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
what type of problem you faced insales project or insurance project
How to load the data from a flat file into the target where the source flat file name changes daily?
How to jion 2 tables, without using any condition?
What is degenerated dimention table?
What is the exact difference b/w IN and EXIST in Oracle..?
What is the difference between warehouse key and surrogate key?
How the facts will be loaded? explain
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
What are the new features of the server manager in the informatica 5.0?
How can we get multiple output values using an unconnected lookup transformation?