Interested to Buy Any Domain ? << Click Here >> for more details...
in a table it has 200 rows the query is select 150 from
tablename.whats the output
- 2 Answers
- 9127 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / qlikstar
select 150 from tab
Ans:150
150
150
--
--
150(200 times)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
How can you validate all mappings in the repository simultaneously?
Can u generate reports in Informatica?
what is the Default Source Option For Update Strategy Transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Design time, run time. If you don't create parameter what will happen
How can you increase the performance in joiner transformation?
What is the different lookup cache(s)?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a pre-defined event and user-defined event?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
