what is inline view?



what is inline view?..

Answer / magnil

A sub query written in the from clause..

Is This Answer Correct ?    12 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


What is the use of transformation?

0 Answers  






i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,


two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,


can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,


ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,


Categories