WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?
chandumba2005@gmai.com
Answers were Sorted based on User's Feedback
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 |
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.
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What is an expression transformation in informatica?
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
what is the function of 'F10' informatica ?
What happens if we dont select data driven option?
draw informatica architecture 8.6 ?
In target table how to display the system time
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.
What is flashback table ? Advance thanks
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
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