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 |
Do you find any difficulty while working with flat files as source and target?
sorce is a flatfile only 1st and last row should insert to target how will u do?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
What you know about transaction control transformation?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
What do you understand by term role-playing dimension?
what is the function of 'F10' informatica ?
What is a look up function? What is default transformation for the look up function?
Performance tuning( what you did in performance tuning)
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?