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
What is Data Caches size?
What is the command used to run a batch?
How many ways a relational source definition can be updated and what are they?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the different types of transformation available in informatica.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is an expression transformation in informatica?
Explain sessions and how many types of sessions are there?
What are the different types of olap? Give an example?
Define enterprise data warehousing?
Explain how to import oracle sequence into informatica?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How can you define user defied event?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Please let me know how to make encryption and decryption with example?
