Informatica Developer: SQL Questions

Thursday 25 March 2010

SQL Questions

Posted by datajunction at 11:37

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: SQL

No comments:

About Me

datajunction

View my complete profile

Labels

Coding Standards (11)
Data WareHousing Books (6)
Developer Guidelines (7)
DWH Concepts (9)
DWH Modeling (31)
Functions in Informatica (5)
IDQ_Parsing Data (2)
Informaica Software (1)
Informatica Basics (11)
Informatica FAQs (50)
Informatica Installation Problems (2)
Informatica Scenerios (17)
Informatica SDLC process (6)
Informatica Transformations (6)
Informatica_materials (4)
Infromatica Testing (1)
NS2 and TCL (1)
Oracle (2)
Oracle FAQs (25)
ORACLE JOINS (8)
SQL (7)
UML (7)
UNIX FAQs (9)

Followers

Popular Posts

How do you perform incremental logic or Delta or CDC?

Incremental means suppose today we processed 100 records ,for tomorrow run u need to extract whatever the records inserted newly and ...
Parsing Data Overview

You can parse data to identify logical elements in one input column and write these elements to multiple output columns. ...
Installing Informatica PowerCenter In windows 7

Hi All installing the informatica power center on Windows 7( problems resolved) befoere clicking the setup right click on the setup->comp...
How to find the Dense rank ?

The DENSE_RANK function works acts like the RANK function except that it assigns consecutive ranks: Select empno, ename, Sal, from (select e...
Difference between Data cleansing and Data scrubbing ?

Data cleansing is a process of removing errors and resolving inconsistencies in source data before loading data into targets. Data scrubbing...
500 Oracle Interview Questions

500 Interview Questions Download
Diff between Active and passive transformation ?

Transformation can be active or passive, active transformation can change the no of records passed to it, a passive transformation can never...
Self Join

Joining the table itself is called self join. Ex: SQL> select e1.empno,e2.ename,e1.job,e2.deptno from emp e1,emp e2 where e1.empno=e2....
Server Variables

he naming conventions for server variables are $PMRootDir = the root directory (Example: \\Server\C:\Program Files\InformaticaPo...
Write the query to transpose rows into columns.

select emp_id, max(decode(row_id,0,address))as address1, max(decode(row_id,1,address)) as address2, max(decode(row_id,2,address)) as address...

Total Pageviews

Blog Archive

► 2011 (199)
- ► July (2)
- ► June (187)
- ► May (1)
- ► January (9)

▼ 2010 (29)
- ► August (6)
- ► May (1)
- ► April (4)
- ▼ March (18)

Reporing

Reports

ETL

business process

Data

Raw Data

Simple theme. Powered by Blogger.

Thursday 25 March 2010

SQL Questions

No comments:

Post a Comment