WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?


chandumba2005@gmai.com

Answers were Sorted based on User's Feedback



WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com..

Answer / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

Is This Answer Correct ?    5 Yes 0 No

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com..

Answer / rams

yes

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,


What is an expression transformation in informatica?

0 Answers  


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


what is the function of 'F10' informatica ?

4 Answers   IBM,






What happens if we dont select data driven option?

2 Answers   Zensar,


draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,


In target table how to display the system time

1 Answers  


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,


What is flashback table ? Advance thanks

0 Answers   Puma,


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,


Categories