Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21353 Views
- I also Faced
- E-Mail Answers
Answer Posted / vaas
Hi pooja,
would rowid be 3?
can u use having clause in ur query?
pl let me know poojaa
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
How many transformations can be used in mapplets.
Why update strategy and union transformations are active? Explain with examples.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Which is the t/r that builts only single cache memory?
What is a surrogate key?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the types of data warehouses?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
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
What are the different ways to implement parallel processing in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can informatica be used for an organization?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
