Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhishek guddu
DECODE FUNCTION YOU CAN FIND IN SQL BUT IIF FUNCTION IS NOT
IN SQL. DECODE FUNCTION WILL GIVE CLEAR READABILITY TO
UNDERSTAND THE LOGIC TO OTHER.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
What is a joiner transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How many ways are there to create ports?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is mapplet in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What do think which one is the better joiner or look up?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Enlist the differences between database and data warehouse.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the types of transformations?
What is a router transformation?
Write the different tools in the workflow manager?
Mention a few design and development best practices for informatica?
